Hello, W! Sunday, June 23, 2013, 9:47:54 PM, you wrote:
WO> I usually write a COMMIT or a ROLLBACK when want to finish a transaction. WO> However in the documentation of ISQL said that SET AUTODDL ON finish the WO> transaction with a COMMIT. remember that ISQL is just a program, that can be rewritten by anyone, so, you may design your own SET AUDODDL behavior. WO> SET AUTODDL ON; WO> INSERT INTO MyTable (Column1, Column2) VALUES (Value1, Value2); WO> QUIT; WO> When I return to ISQL the table has not recorded the INSERT. Of course, if WO> I write EXIT instead of QUIT the INSERT is recorded but that is the WO> standard behaviour of ISQL. Yes, QUIT = ROLLBACK, EXIT = COMMIT. And, consider that AUTODDL ON forces commit before NEXT sql statement. So, the code here may be like that: OnNewStatement if InTransaction and AutoDDL then Commit; ExecuteNewStatement; -- Dmitry Kuzmenko, www.ib-aid.com
