Thread View: borland.public.vdbase.data.sql
1 messages
1 total messages
Started by Andrea
Mon, 22 Mar 1999 00:00
Form filter
Author: 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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads