🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

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

#1422
From: J. Korth
Date: Mon, 02 Feb 1998 00:00
33 lines
1497 bytes

Dear Bowen:

my problem is:
>>1) But how can I force the datamodule to display only (!) main table
>>entries for which a child table exists?

and you wrote:

>Experiment with a rowset.canGetRow event handler, e.g.:
>with (this.ParentQuery.rowset)
>   indexName = "whatever"
>   canGetRow = {||not this.parent.parent.ChildQuery.rowset.endOfSet}
>endwith


This does not work.
When being in the CanGetRow event of the parent table,
one can not be sure that the rowsets of the child tables are set
correctly!
E.g. if CanGetrow of the parent table returns FALSE and if then
CanGetrow is called a second time for the next parent table entry, the
rowset of the child tables is still the same!

The only solution I found is to re-link the masterrowset property of
the rowsets of all child tables in the cangetrow event of the parent
table. Then one can test as you mentioned it above.
However, the program becomes deadly slow!
Any other ideas?

Thanks,
Jens
Technical Details
Message-ID: <6b4qru$51q9@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> <6b3qe5$4hi8@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: airports@aol.com (J. Korth)
Subject: Re: Linking native tables  (earlier:Rowset read-only)
Date: 1998/02/02
Message-ID: <6b4qru$51q9@forums.borland.com>
X-Deja-AN: 321384255
References: <34CE113E.3680@mbox.vol.it> <6als9i$sig15@forums.borland.com> <6b31rt$4br7@forums.borland.com> <6b3qe5$4hi8@forums.borland.com>
Organization: None
Newsgroups: borland.public.vdbase.data.sql