Quickreport + ADO is driving me crazy.....

Thread View: borland.public.cppbuilder.database.ado

2 messages

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

2 total messages Started by Olov Lundin Thu, 16 Nov 2000 11:34

#6005

Author: Olov Lundin
Date: Thu, 16 Nov 2000 11:34

14 lines
1438 bytes

Hi
I�m trying to create a Master/Detail report based on 2 ADOQueries, the
first query picks up data from the master-table och the second is
supposed to pick up data from the detail-table. My problem is that I
don�t know how to create as Mater/Detail relationship between the two
queries.
I�ve tried setting the SQL-statement to SELECT......WHERE
Startnummer=query1->Fields->FieldByName("Startnummer")->AsString ....
for the second query but it allwats picks up the data for the first
"MasterRecord"

Does anybody have a suggestion how I should solve my problem???

Olle

Re: Quickreport + ADO is driving me crazy.....

#6023

Author: Junlin Xie
Date: Tue, 21 Nov 2000 08:16

23 lines
1750 bytes

See the help content of property DataSource of TQuery, I'll find the answer.


"Olov Lundin" <olov.lundin@thoreb.se> wrote in message
news:3A13C62E.16E0BFD1@thoreb.se...
> Hi
> I�m trying to create a Master/Detail report based on 2 ADOQueries, the
> first query picks up data from the master-table och the second is
> supposed to pick up data from the detail-table. My problem is that I
> don�t know how to create as Mater/Detail relationship between the two
> queries.
> I�ve tried setting the SQL-statement to SELECT......WHERE
> Startnummer=query1->Fields->FieldByName("Startnummer")->AsString ....
> for the second query but it allwats picks up the data for the first
> "MasterRecord"
>
> Does anybody have a suggestion how I should solve my problem???
>
> Olle
>
>
>
>

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