Article View: borland.public.vdbase.data.sql
Article #58Form filter
From: Andrea
Date: Mon, 22 Mar 1999 00:00
Date: Mon, 22 Mar 1999 00:00
44 lines
1681 bytes
1681 bytes
Hi,
I would like to know how i can resolve this problem:
I have a form with 2 table in relation father-child 1:N;
I must select the father's record that have a field of the child table equal
to .... (to modified it!)
I input the filter option in a entryfield object and then...
How i can do for filter also a field of the child table?? Can i do the
CanGetRow() How i can use it??
Example of may source code:
this.QUERY1 = new QUERY()
this.QUERY1.parent = this
with (this.QUERY1)
left = 55
top = -0.0455
database = form.database1
sql = 'select * from "father.dbf"'
active = true
endwith
this.QUERY2 = new QUERY()
this.QUERY2.parent = this
with (this.QUERY2)
left = 65
top = -0.0455
database = form.database1
sql = 'select * from "child.dbf"'
active = true
endwith
with (this.QUERY2.rowset)
filterOptions = 3
indexName = "CALNOT"
masterRowset = parent.parent.query1.rowset
masterFields = "CALCIAID"
endwith
Please help me and i would like that replay to this with an example with the
use of the COSTRAIN between the two my table (apply the example to the my
example...)
Thank's in advance ... Andrea
Technical Details
Message-ID:
<7d6chn$jla1@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,e4149e4a8255ab03,start X-Google-Attributes: gidff5a1,public From: "Andrea" <calciotel@lunet.it> Subject: Form filter Date: 1999/03/22 Message-ID: <7d6chn$jla1@forums.borland.com> X-Deja-AN: 457710774 Organization: Another Netscape Collabra Server User X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Newsgroups: borland.public.vdbase.data.sql