Joining the results of two datasets.

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

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

2 total messages Started by Clara D�az Wed, 24 Jan 2001 09:39

#848

Author: Clara D�az
Date: Wed, 24 Jan 2001 09:39

7 lines
1208 bytes

I have a dataset placed in my datamodule (datasetA). In one form, I have
another dataset (datasetB). In this form, I would like to join the result of
datasetA to the result of datasetB without having to execute both queries
again. Is there any way of doing this or do I have to execute an sql query
with an union statement?

Thanks in advance.

Re: Joining the results of two datasets.

#849

Author: Mark Cashman
Date: Thu, 25 Jan 2001 04:35

16 lines
1533 bytes

Hi, Clara!

You can use master / detail relationships or programatic Locate() to
simulate joining the queries.

If you have questions about that, visit
borland.public.cppbuilder.database.desktop

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

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