Abnormal problem: exit program rollback ALL!!!!

fringui · Post by **fringui** » 15.10.2009, 17:08

Hi, i use delphi 7, zeoslib 6.6.5 stable and MsSQL.

I make some edit in a table from software X in pc A.
At this time i use a PC B and software Y and i see the edit of pc A.

When i close the program in pc A after some edit record i lost all data!!

All record i have edit i have a BIG rollback and i lot all edit!!

Why?!?!?!

I have Zconn with Autocommit True
I use Zquery with update sql, cachedupdate false.

Thank a LOT!!

guidoaerts · Post by **guidoaerts** » 16.10.2009, 17:49

Maybe this is a stupid question : did you Post?
Guido

fringui · Post by **fringui** » 18.10.2009, 20:54

Yes, i post, i try to commit, i try all combination of commit, cache update.. etc etc... no solution :'(

I try to make a sql update (update table set field=1 where ...)
No difference.

I update, the data is in the table, i see it from my program, from another program in another pc.. but when i close my program all data rallback!

Help me!
Thanks!!

Post by **mdaems** » 24.10.2009, 13:56

Hi,

I don't know but it looks like mssql supports 2 commit levels from your description. A 'soft' commit after every update with autocommit. And a definitive commit that should happen before closing the connection. Is that TRUE?

Do you close the query and connection before shutting down your program?

Mark