Article View: borland.public.vdbase.data.sql
Article #1422Re: Linking native tables (earlier:Rowset read-only)
From: J. Korth
Date: Mon, 02 Feb 1998 00:00
Date: Mon, 02 Feb 1998 00:00
33 lines
1497 bytes
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-mailReferences:
<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