| View previous topic :: View next topic |
| Author |
Message |
Thomas J. Theimer
Guest
|
 Posted: Thu Aug 14, 2003 6:08 pm Post subject: One SQL server request for two DataSets |
 |
|
I have an application with two TQuery decendents making identical
requests to the database server - one is used as a detail data set in
a master-detail relationship and the other is used as a look up data
set for a look up field in another data set.
I am looking for a way to query the server once but be able to hold
and use the result as two separate data sets without requiring that I
write a table or ClientDataSet file to the local hard drive .
I've tried several approaches but each time hit a dead end. Any
assistance appreciated.
|
|
| Back to top |
|
 |
Stephen Beausang
Guest
|
| Posted: Thu Aug 14, 2003 8:08 pm Post subject: Re: One SQL server request for two DataSets |
|
|
You can certainly use two client datasets to access the same query on the
server. This would still be two copies of you data. If you use
Clientdataset.clonecursor then you would really have one copy of the data.
Neither of these methods would require saving data locally
Stephen
"Thomas J. Theimer" <ttheimer (AT) TheTechPart (DOT) com> wrote
| Quote: | I have an application with two TQuery decendents making identical
requests to the database server - one is used as a detail data set in
a master-detail relationship and the other is used as a look up data
set for a look up field in another data set.
I am looking for a way to query the server once but be able to hold
and use the result as two separate data sets without requiring that I
write a table or ClientDataSet file to the local hard drive .
I've tried several approaches but each time hit a dead end. Any
assistance appreciated.
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
