Subject | RE: [firebird-support] Re: Inserting 100's of thousands from a SP |
---|---|
Author | Clay Shannon |
Post date | 2005-07-11T19:35:01Z |
<<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
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