🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.vdbase.data.sql
1 messages
1 total messages Started by Andrea Mon, 22 Mar 1999 00:00
Form filter
#58
Author: 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
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