Would like to use ADO for Client Side Temporary Data Store...

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Joe L. Thu, 28 Jun 2007 14:24

#219

Author: Joe L.
Date: Thu, 28 Jun 2007 14:24

15 lines
1759 bytes

Is it possible to create a TADODataSet, populate it with some records, 
and save it to a file (e.g. SaveToFile to be later opened with 
LoadFromFile) without connecting to a server. I'm getting errors that 
the ADODataSet can not be opened without a connection or connection 
string defined.  Is there a specific way that I should populate this 
information if I want the ADODataSet to be self-sufficient.

In the short term I just want to use the DataSet to organize data from a 
flat file to a more logical representation of the data, that is easier 
to work with.  Should I just use, TClientDataSet.  I wanted to use 
TADODataSet as I thought it might ease migration to a central data store 
later a little easier (not in my short term plans).

Thanks,
Joe

Re: Would like to use ADO for Client Side Temporary Data Store...

#220

Author: Joe L.
Date: Thu, 28 Jun 2007 16:48

6 lines
1235 bytes

Answered my own question.  Since I didn't load the data from another 
source, I needed to call the TADODataSet::CreateRecordSet() function to 
have an empty working recordset to work with.

Thanks,
Joe

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads