Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Commit only when server is closed?
Commit only when server is closed?
Posted: 2007/08/17 12:24
 
Hi,

I am using Interbase and the IBX version of the server. It seems as if it doesn't do a commit to the database until the server is closed. I can't find any way to force a commit on the database-components. I have a Interbase tool which I refresh and the save to the database isn't until the server is closed.

Regards, Fredrik.
Re:Commit only when server is closed?
Posted: 2007/08/21 04:25
 
Hello

Please, open daTDServer.pas unit. Find there TTDSQLProcessor.DoFinishUpdates method and post it here. I am not sure, that you have correct ThinDAC version.

Regards,
Dmitry
Re:Commit only when server is closed?
Posted: 2007/08/21 04:58
 
OK, I went into that procedure and changed this:

// if not AInfo.FInTransaction and (AInfo.FProv <> nil) then
if AInfo.FInTransaction then

Now it calls psendtransaction and i can view it from other applications. However I have no idea what FProv do and if this is the suggested change you wanted me to do.

BTW, I am using the latest release (1.31).

Regards, Fredrik.