Article View: borland.public.vdbase.data.sql
Article #150Filter on a child table of a realtion.
From: Andrea
Date: Thu, 04 Mar 1999 00:00
Date: Thu, 04 Mar 1999 00:00
52 lines
1729 bytes
1729 bytes
Hi,
i have this problem:
In a form i have 2 tables in father-child relation as the sample;
this.DATABASE1 = new DATABASE()
this.DATABASE1.parent = this
with (this.DATABASE1)
left = 7
top = 2
databaseName = "PIPPO"
active = true
endwith
this.QUERY1 = new QUERY()
this.QUERY1.parent = this
with (this.QUERY1)
left = 14
top = 2
database = form.database1
sql = 'select * from "father.dbf"
active = true
endwith
this.QUERY2 = new QUERY()
this.QUERY2.parent = this
with (this.QUERY2)
left = 20
top = 2
database = form.database1
sql = 'select * from "child.dbf"
active = true
endwith
with (this.QUERY2.rowset)
indexName = "CODICEID"
masterRowset = parent.parent.query1.rowset
masterFields = "PADREID"
endwith
How a can do for filter the record of the father table for a field of the
child table???
I use the form.query2.rowset.filter="CAMPO=(valore)" but don't work...
I use the relation because in the same form i have also other filter for
other fields of the father table that make a seletion on the realtion...
Is it possible use the COSTRAIND of the old visual dbase 5.6 and if yes
where???
Thank's
Andrea.
Technical Details
Message-ID:
<7bl897$3mg1@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,ec91fde70541d690,start X-Google-Attributes: gidff5a1,public From: "Andrea" <calciotel@lunet.it> Subject: Filter on a child table of a realtion. Date: 1999/03/04 Message-ID: <7bl897$3mg1@forums.borland.com> X-Deja-AN: 451057063 Organization: Guastini Newsgroups: borland.public.vdbase.data.sql X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4