How to get the records of distinct ADOQuerys

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

2 messages

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

2 total messages Started by Jose Wed, 07 Feb 2001 16:47

#5763

Author: Jose
Date: Wed, 07 Feb 2001 16:47

10 lines
1103 bytes

I have an Access database with several tables, and I make one query for each
table. How can I get all the records together.

For example.
   ADOQuery1 returns 10 records
   ADOQuery2 returns 5 records

I wan to get a table with 15 records.

Is there any way to do that

Re: How to get the records of distinct ADOQuerys

#5764

Author: Alexei Karas
Date: Thu, 08 Feb 2001 12:29

23 lines
1431 bytes

You may:
a) use UNION SQL's clause
b) create disconnected ADO recordset with structure you need and fill it
with data from your queries
Use what best fit your needs.

HTH,
       Alexei

"Jose" <jpazos@integratel.es> wrote in message news:3a817c1c_1@dnews...
> I have an Access database with several tables, and I make one query for
each
> table. How can I get all the records together.
>
> For example.
>    ADOQuery1 returns 10 records
>    ADOQuery2 returns 5 records
>
> I wan to get a table with 15 records.
>
> Is there any way to do that
>
>

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