Subject Re: Issue: deadlock with Firebird and Delphi. ref/eDN7002040583
Author derryckw
Hi Dennis,

Do you roleback the transaction as part of the exception handling
code ?

"roleback" is cruscial if you want to retry posting the record.


"Dennis" <dennis@...> wrote:
> >
> > Repeat
> >
> > Try
> >
> > Post;
> >
> > Ok:=true;
> >
> > Except
> >
> > If Dialog('retry?')=no then usercancel:=true;
> >
> > Ok:=false;
> >
> > End; // except
> >
> > Until ok or usercancel.
> >
> > If ok then commit;
> >