--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<developer@l...> wrote:

>
> 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?

Remember to but an enter after the

commit;

or it will not work.

Adam