Detail with 2 TQuery Objects...

patrick allen

Delphi Developer

Sun, 17 Mar 2002 03:00:00 GMT

Master/Detail with 2 TQuery Objects...

setup: i have two grids which present a master/detail relationship view using two ttable
objects. i now want to use two tquery objects in order to utilize the flexibility
of sql to filter the data.

what is the sql that must be used with the detail tquery object so that it retrieves
only the detail rows associated with the currently selected master row?

note: the primary and foreign key is the 'ContactID' field.

John Elric

Delphi Developer

Sun, 17 Mar 2002 03:00:00 GMT

Re:Master/Detail with 2 TQuery Objects...

You can tie the master to a datasource and set the DataSource property of
the Detail SQL. This will perform the Master/Detail operation you desire.

John Elrick

Quote

patrick allen <pal...@fred.net> wrote in message news:37f24615@newsgroups...

> setup: i have two grids which present a master/detail relationship view
using two ttable
> objects. i now want to use two tquery objects in order to utilize the
flexibility
> of sql to filter the data.

> what is the sql that must be used with the detail tquery object so that it
retrieves
> only the detail rows associated with the currently selected master row?

> note: the primary and foreign key is the 'ContactID' field.

Other Threads

1. Master-Detail problem with tquery as detail

2. TQuery and TQuery Master-Detail relationship

3. TQuery and TQuery Master-Detail relationship

4. Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

5. Master/Detail w/SQL Server shows all detail records when inserting a new master record

6. Problem: Master/Detail shows details during Master Insert

7. Master-Detail TSession TQuery Error

8. Master/Detail with TQuery components

9. TQuery Master/Detail linked with other DataSource

10. MASTER/DETAIL TQUERY