🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Form filter

#58
From: Andrea
Date: Mon, 22 Mar 1999 00:00
44 lines
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-mail

Show 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