SQL Anywhere Mobile - AutoCommit & Application Exit

Author

AutoCommit & Application Exit

handheldmaster

2005-05-19, 1:24 pm

This is an ultralite question .. but posting to the mobilink
newsgroup as ultralite one does not allow me to create a new
topic.

If following events occur

Connection.AutoCommit = False
...Inserts
...Updates
...(Deletes) DeleteAllRows
End (application exits -- completely remove from memory)

Question: Will the inserts/updates be commited when the
application exits ? or these are lost.

Windows Mobile 2003 - Ultralite 8.0.2(4392) - MVB 3.5 (0633)
- Using SD card to store .udb file.

David Fishburn

2005-05-20, 3:24 am

handheldmaster wrote in news:428cdea1.1b75.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

h> If following events occur
h>
h> Connection.AutoCommit = False
h> ..Inserts
h> ..Updates
h> ..(Deletes) DeleteAllRows
h> End (application exits -- completely remove from memory)
h>
h> Question: Will the inserts/updates be commited when the
h> application exits ? or these are lost.
h>
h> Windows Mobile 2003 - Ultralite 8.0.2(4392) - MVB 3.5 (0633)
h> - Using SD card to store .udb file.

I would say they are rolled back since you did not explicitly issue a
"COMMIT".

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links