At 11:39 AM 10-09-02 +0000, Arveesri Butpo wrote:

>I'm new for Firebird and trying to convert MS SQL stored procedures to
>Firebird manually. I can't insert a record into a table without commit. But
>when I put COMMIT statement in it, it showed an error, "Reserved Word".
>So do you have any suggestion to commit a transaction in the stored
>procedure? or any ideas?...

You don't. Stored procedures are intended to be part of a transaction that
gets all committed or all rolled back. If SPs are able to embed and commit
transactions, you lose the atomicity that transactions are designed to
provide. MSSQL needs this capability (and thus to defeat atomicity)
because of its need to create temporary tables. In Firebird you don't need
to create temp tables since you can output resultsets directly in what is
termed a "selectable stored procedure".

If you want to batch up SQL statements and commit as you go, use a DML script.

For further support, please use the ib-support list. Subscribe by clicking
this link and sending off the resulting email:

mailto:ib-support-subscribe@yahoogroups.com

Helen