Been down that road thanks Max.
-----Original Message-----
From: Max Renshaw-Fox <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Wednesday, 10 November 1999 22:49
Subject: RE: [DUG]: ADO Query Question
Tony - does this help?
ADO dataset components provide the ability to cache changes to the dataset
and then either apply all of the changes as a batch operation or to cancel
one or all of the changes. Batch updates can serve as a sort of transaction
control, but at the dataset component level. (Ordinarily, transactions are
handled as methods of the ADO connection component.)
Using the batch updates features of ADO dataset components is a matter of:
Opening the dataset in batch update mode
Inspecting the update status of individual rows
Filtering multiple rows based on update status
Applying the batch updates to base tables
Canceling batch updates
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Tony Blomfield
Sent: Wednesday, 10 November 1999 14:47
To: Multiple recipients of list delphi
Subject: [DUG]: ADO Query Question
HI.
Heres the problem.
Imagine a query like this
Select 'T', Description from Sometable
The reason for the pseudo first column in this case is simply so we can set
a checkbox in a DB grid. The user can walk up and down the grid checking or
unchecking items, then when he clicks OK, processing takes place
based on the check box value.
With BDE this is easy, just turn Cached Updates on and never apply the
updates, or use a ClientDataset.
I am having trouble getting this to work with ADO (Obviously I dont
understand ADO!) ADO is smart enough to recognise the first column as not
really existing and complains bitterly.
Basically I want the user to be able to play with any dataset with complete
disregard for the underlying database object properties.
Has anyone else confronted this issue? I could hook a Client Dataset up to
the ADOQuery, but suspect that I might be mising something obvious and there
is something I can do directly to ADO query to fully isolate it.
My cursor is set to client side, and the Provider is SQLOLEDB.1
Any ideas?
Thanks,
Tony.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
