Local Mode ADO DataSet

Giganews Newsgroups
Subject:Local Mode ADO DataSet
Posted by: Erik Berry (…@techieZZZ.com)
Date:Fri, 26 Jun 2009

Can anyone point me to an example of creating a "local mode" dataset using
TADOQuery or TADODataSet.  I want to get some data from a server and then
disconnect the dataset where I can still edit it, but where the changes do
not get posted back to the server.  Some might refer to this as converting it
to an in-memory dataset.  I want to manually run some queries to perform the
updates and inserts the user makes, since there are some related tables that
need updating when this dataset is edited.

I realize I can do this with TClientDataset, but for various reasons, I'd
prefer to directly use the existing ADO dataset, if possible.

Erik

Replies