Subject | Re: [firebird-support] how to commit a script |
---|---|
Author | Pavel Menshchikov |
Post date | 2005-12-30T15:49:10Z |
Hello,
d> I have a script file which i execute with isql.exe -q -i.
d> The script file contains EXECUTE PROCEDURE statement. How do i commit
d> once the procedure is executed?
d> I tried putting COMMIT in the script file but it does not work...
COMMIT WORK should work (AFAIR, WORK is optional). What's the error in
your case? Didn't you forget a statement terminator (";" or whatever
you set with SET TERM) after EXECUTE PROCEDURE or COMMIT?
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com
d> I have a script file which i execute with isql.exe -q -i.
d> The script file contains EXECUTE PROCEDURE statement. How do i commit
d> once the procedure is executed?
d> I tried putting COMMIT in the script file but it does not work...
COMMIT WORK should work (AFAIR, WORK is optional). What's the error in
your case? Didn't you forget a statement terminator (";" or whatever
you set with SET TERM) after EXECUTE PROCEDURE or COMMIT?
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com