🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1420

Re: Linking native tables (earlier:Rowset read-only)

#1420
From: Bowen Moursund
Date: Mon, 02 Feb 1998 00:00
18 lines
1218 bytes
>1) But how can I force the datamodule to display only (!) main table
>entries for which a child table exists?
>
>2) And how do I make a filter that includes conditions for the main
>and the child table, which must all(!) be true to make the datarow
>valid?

Experiment with a rowset.canGetRow event handler, e.g.:

with (this.ParentQuery.rowset)
   indexName = "whatever"
   canGetRow = {||not this.parent.parent.ChildQuery.rowset.endOfSet}
endwith
____
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm
Technical Details
Message-ID: <6b3qe5$4hi8@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <34CE113E.3680@mbox.vol.it> <6als9i$sig15@forums.borland.com> <6b31rt$4br7@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,128d322c77aeed66
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <supportinfo@borland.com>
Subject: Re: Linking native tables  (earlier:Rowset read-only)
Date: 1998/02/02
Message-ID: <6b3qe5$4hi8@forums.borland.com>
X-Deja-AN: 321282732
Content-Transfer-Encoding: 7bit
References: <34CE113E.3680@mbox.vol.it> <6als9i$sig15@forums.borland.com> <6b31rt$4br7@forums.borland.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: DataTech
Newsgroups: borland.public.vdbase.data.sql