At 05:23 p.m. 29/04/2014, [email protected] wrote: >When I run that procedure on flamerobin with this command: > >execute procedure Reg. > > >It runs ok, but without a commit command, the field1 on table won't get update. > >I rarely use store procedure to do update / insert / delete, but is this a >normal behavior?
Everything you do in Firebird happens in a transaction context, e.g., start transaction do some selects do some deletes run a stored procedure do some more stuff commit transaction >Is there any commands to add so commit is no needed? No. The work done by the transaction remains isolated until COMMIT is called. If the transaction is not committed, the database state does not change. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of "The Firebird Book" and "The Firebird Book Second Edition" http://www.firebird-books.net __________________________________________________________________
