Re: Setting a Filter in a grid

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

Article #491

Back to borland.public.vdbase.data.sql Previous Next

#491

From: John Staub
Date: Tue, 08 Dec 1998 00:00

22 lines
1537 bytes

Geoff,

  The master-detail relationship is not really what I was looking for.  I'm
trying to build a form with fields from two linked tables and a grid.  The
user would start a filter, enter information in the fields, apply the
filter, and the results would show in the grid.  Problem is, I'm trying to
use comboboxes as opposed to entryfields for the linked fields and it ain't
working<g>.  I may go back to entryfields until I work out the combobox
issue.  I figured if I could build the appropriate SQL statement into the
onclick event of a pushbutton, I could select records from the two tables
and have them appear in the grid, sorta like a quasi filter.

thanks,

John
Geoff S. Wass wrote in message <366CB6F2.1272F2DB@ibm.net>...
>John,
>
>Since you are working with dBASE tables, don't use SQL unless you have
>to. Instead use the Master-detail linking and implement it using a
>dataModule (so that you can reuse it). Look for "Linking master-detail
>in local tables" in the online help.

Technical Details

Message-ID: <74j444$9iv7@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <74hdsp$8f74@forums.borland.com> <366CB6F2.1272F2DB@ibm.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,aad4e58c13b985c4
X-Google-Attributes: gidff5a1,public
From: "John Staub" <bmds@worldnet.att.net>
Subject: Re: Setting a Filter in a grid
Date: 1998/12/08
Message-ID: <74j444$9iv7@forums.borland.com>
X-Deja-AN: 420020879
References: <74hdsp$8f74@forums.borland.com> <366CB6F2.1272F2DB@ibm.net>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message