L
Leonard Danao
-- Sorry for teh cross post ---
Good day all, Quick question about Datasets
If someone can point me to a site/manual/etc where i can get the following
information i will be very greatful
My program grabs a set of data from SQL and fills a dataset,
First i want to grab the distinct Customers from this dataset
Then using that I want to build subqueries from the distinct Customers to
get the other necessarry information from the same dataset
SAMPLE CODE
PartsData = GetSQLData(sqlquery) ' takes the sqlquery and returns a dataset
DistinctCustomers = PartsData.Tables(0).Select("DISTINCT CustomerID")
The error i get is "Additional information: Syntax error: Missing operand
after 'DISTINCT' operator."
Where can i find the proper syntaxt for a dataset.tables.select and is
DISTINCT possible on a subquery of a dataset?
I would rather use the disconnected dataset than create multiple trips to
the DB if possible, but if i have to, I have to...(which I am currently
doing)
Thanks to all that respond
Also if you can CC my email address LDANAO[SPAM BLOCKER]@itsllc.com i would
be greatful, delete the SPAM BLOCKER block
Good day all, Quick question about Datasets
If someone can point me to a site/manual/etc where i can get the following
information i will be very greatful
My program grabs a set of data from SQL and fills a dataset,
First i want to grab the distinct Customers from this dataset
Then using that I want to build subqueries from the distinct Customers to
get the other necessarry information from the same dataset
SAMPLE CODE
PartsData = GetSQLData(sqlquery) ' takes the sqlquery and returns a dataset
DistinctCustomers = PartsData.Tables(0).Select("DISTINCT CustomerID")
The error i get is "Additional information: Syntax error: Missing operand
after 'DISTINCT' operator."
Where can i find the proper syntaxt for a dataset.tables.select and is
DISTINCT possible on a subquery of a dataset?
I would rather use the disconnected dataset than create multiple trips to
the DB if possible, but if i have to, I have to...(which I am currently
doing)
Thanks to all that respond
Also if you can CC my email address LDANAO[SPAM BLOCKER]@itsllc.com i would
be greatful, delete the SPAM BLOCKER block