I changed the code, the loop now is different at all using rollback method
and it works fine!



Thank you all guys for your help.

Dennis





_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of derryckw
Sent: Wednesday, December 13, 2006 10:31 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Issue: deadlock with Firebird and Delphi.
ref/eDN7002040583



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;
> >

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