Subject commit in stored procedures
Author Maurizio P.
hi ,
i should write a Stored Procedure where i first delete all
the records of a table , and then i repopulate
it with some calculations .

I did it with Delphi so i call applyupdates method of the
dataset at the end of the Delphi procedure when
i am sure that no errors happened .

I am tring to have the same result with
Firebird stored procedures and i ask if there is something
like :

create procedure TEST
start transaction
.... code o the procedure
commit transaction

I want that the table is updated only
at the end of the procedure .



[Non-text portions of this message have been removed]