Subject | RE: [firebird-support] Re: Issue: deadlock with Firebird and Delphi. ref/eDN7002040583 |
---|---|
Author | Dennis |
Post date | 2006-12-13T08:49:20Z |
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:
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:
> >[Non-text portions of this message have been removed]
> > 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;
> >