Subject RE: [firebird-support] Re: Inserting 100's of thousands from a SP
Author Clay Shannon
<<I changed SQL Server for FB some years ago. At that time, i used
commits and rollbacks inside stored procedures, and at the first
moment i missed this feature in FB. >>

What do you mean? I use commit and rollback with stored procs all the time
in FB (using FIB components in Delphi):

try
spDelete.ExecProc;
transDelete.Commit;
except
on e: Exception do begin
InsertExceptionDataEx(Application.ExeName,
Application.Title,
e.ClassName,
e.Message,
SysErrorMessage(GetLastError),
GetLastError,
GetMachineName,
TPFIBDatabase(sp.Database));
transDelete.Rollback;
end;

<< Today i see there are other ways to achieve the same behavior and i
don't see any big benefit to have this feature implemented. I'm not
saying it's useless. Just that it probably doesn't worth to implement it.>>

I could live without beer and filet mignon and chocolate, too, but I prefer
not to.

Clay Shannon,
Dimension 4 Software