I have a program that uses Firebird 2.1. Most installation use the embedded version so I prefer to stick with 2.1 since it does all I need.
I have a question about transactions: if I start a transaction, I add or modify some data, then the program gets an exception and it crashes, what happens to the transaction? I was believing that if the program terminates without calling commit or rollback, then the transaction is automatically rolled back. Now a customer had a problem that can be explained if the transaction is not rolled back, but the data changes remained in the database even if commit was not called because the program crashed before calling it. Can anybody explain if changed data in this situation remains in the database of is it rolled back? Thanks in advance Fulvio Senore ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
