Re: Querying an ADODataSet
- From: "Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx>
- Date: 25 Mar 2006 04:54:51 -0700
George Kuascha wrote:
Using D6 with MSAccess2000 ... how do you write an
ADODataSet.CommandText to SELECT data FROM another ADODataSet?
you can't use SQL for that. The commandText property is there for
sentences that affect the underlying database, not other datasets.
I get an error message stating that ADO is looking for a table or
query. I suspect that ADO is looking for this table or query in the
Access database instead of from within the app.
well suspected <g>
If you want to put into a dataset X just part of the data contained in
another dataset Y there are 2 ways:
- save the data in dataset Y to the database and execute a select with
whatever parameters in the dataset X.
- move the data yourself. You can do this for example by filtering the
rows you want and move them one by one.
IMO the best option is the first
--
Best regards :)
Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam
.
- References:
- Querying an ADODataSet
- From: George Kuascha
- Querying an ADODataSet
- Prev by Date: Querying an ADODataSet
- Next by Date: Re: Currency Fields In Dynamic ADO Queries
- Previous by thread: Querying an ADODataSet
- Index(es):
Relevant Pages
|
