Filter table

Thread View: borland.public.vdbase.forms

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Andrea Mon, 22 Mar 1999 00:00

#133

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

Re: Filter table

#135

Author: Bowen Moursund (dBASE, Inc.)
Date: Tue, 23 Mar 1999 00:00

10 lines
835 bytes

I answered an almost identical question from you in this message, several
weeks ago:

From: "Bowen Moursund (TeamB)" <bowenSEND_ME_NO_SPICED_HAM@nerds.com>
Newsgroups: borland.public.vdbase.data.bde
Subject: Re: Sql filter.
Date: Thu, 4 Mar 1999 10:43:22 -0600
__
Bowen Moursund (dBASE, Inc.)
bowen at nerds dot com

Re: Filter table

#136

Author: Andrea
Date: Wed, 24 Mar 1999 00:00

22 lines
1279 bytes

OK and i thank you for that but i don't understand how i can apply the
costrain to the two table because the your example is referred to a general
application and i don't know (i am novice) how apply it  to my problem.

I would like if kindly respose me with a more specific example.
thank's and excuse me for my ignorance.
Andrea.

Bowen Moursund (dBASE, Inc.) ha scritto nel messaggio
<7d8jfs$lao23@forums.borland.com>...
>I answered an almost identical question from you in this message, several
>weeks ago:
>
>From: "Bowen Moursund (TeamB)" <bowenSEND_ME_NO_SPICED_HAM@nerds.com>
>Newsgroups: borland.public.vdbase.data.bde
>Subject: Re: Sql filter.
>Date: Thu, 4 Mar 1999 10:43:22 -0600
>__
>Bowen Moursund (dBASE, Inc.)
>bowen at nerds dot com
>
>

Re: Filter table

#137

Author: Bowen Moursund (dBASE, Inc.)
Date: Wed, 24 Mar 1999 00:00

11 lines
947 bytes

>I would like if kindly respose me with a more specific example.

Come on over to the new dBASE newsgroups, repost your question, and I'll see
if I can cook up an example that applies to your specfifc situation.

The new newsgroups can be accessed through this private news server:

  news.dbase2000.com
__
Bowen Moursund (dBASE, Inc.)
bowen at nerds dot com

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