ODBC. How to force data to be written to the disk?

[A. Ostroverkhov]

Hi everybody!

I have a problem while updating data in a database using ODBC.

My application adds new records to the database and soon after tries to read these new records from the database. As a result of buffering, data I read mismatches data I've just written. Thus I need to force data in the buffer to be written to the disk.

In MS SQL it's possible to perfom, using CHECKPOINT statement.

Thank you in advance.

A. Ostroverkhov

[antares686]

WHat type of databae on the backend of the ODBC?

[ksl]

When I was using an Access database from multple applications I have seen a similar problem.

I solved the problem by closing and reopening the CDatabase object that was used for accessing the database. This gives a very slow performence, but soves the problem.

[M Owen]

A,

The next most important question is what language are you doing this in?

[ksl]

I am writing the code in C++ using recordsets derived from the MFC class CRecordset. In the constructor of the objects I always used a CDatabase object.

[ergas]

I think, what you need is called Transaction.
The transaction commands, such as BeginTrans, CommitTrans, or Rollback, in MFC are members of class CDaoWorkspace.

[M Owen]

A,

If I remember to, I'll post some ADO code I wrote that has no delay in it ... It too goes thru ODBC but it does not use the CRescordset class ... You decide what you want to do with it ...

- Mike