asked on

Serialize Data from a Database

I Store some data from a test in a database (MsAcces). Is it possible to serialize this data in one file. I must store the data from one test in one file. I used the database as a buffer.(No dataloss when there is a powerfaillure).
The data is stored from a DaoRecordView in the database

KangaRoo

Did you test MS Access against this no- dataloss? Maybe easier to implement a non-cached system directly.
Anyway, it is pretty simple to export data from an MS Access database 'manually' and this procedure can be automated. All a bit clumsy though.
Another way would be to use ODBC or DAO and get the data back from the database. Powerfailure wouldn't be a problem once it is safely stored in the MDB

Degrave

ASKER

Thanks to KangaRoo

I get the data from the dao-database back in a view (I put it in a Datagrid).
It should be possible to Serialize the Datagrid (or the data with the m_pSet->Serialize function), but I don't know how to do this.
Serializing data only seems to work when you put in the Document
Is it possible to Serialize data in a View without putting it in the Document???

ASKER CERTIFIED SOLUTION

KangaRoo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Degrave

ASKER

Hello,

I already found a way to serialize the data. In the document, I've a member from my recordset. So, I get the data and I serialize every datapoint.
To get the data, I made a While-loop, but it didn't work. I had to do it with a for-loop. (I think it was a problem with the member function Set.IsEof())

Thanks for your comment