Subject | RE: [IBO] Thread - Explict Logic Transactions |
---|---|
Author | Jason Wharton |
Post date | 2004-11-03T17:03:28Z |
It should be just fine.
You just have to handle the exceptions or it could cause your process to
terminate.
Re-raising it is leaving it unhandled as far as this is concerned even
though you did the rollback.
Jason
You just have to handle the exceptions or it could cause your process to
terminate.
Re-raising it is leaving it unhandled as far as this is concerned even
though you did the rollback.
Jason
> -----Original Message-----
> From: Vincenzo Scarpellino [mailto:vincenzoscarpellino@...]
> Sent: Wednesday, November 03, 2004 12:44 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Thread - Explict Logic Transactions
>
>
>
> This is my code, is it correct to do explicit transaction in
> a thread or it can be cause of problems ?
>
> procedure TEurStampaThread.Execute;
> begin
> PostMessage(Handle, WM_NULL, 0, 0);
>
> with FormStLGThread do
> begin
> try
> IBConnect.StartTransaction;
>
> IBOQueryPNO.Open;
>
> IBConnect.Commit;
> except
> IBConnect.RollBack;
> raise;
> end;
> end
> end;
>
> ----- Original Message -----
> From: Jason Wharton
> To: IBObjects@yahoogroups.com
> Sent: Tuesday, November 02, 2004 6:41 PM
> Subject: RE: [IBO] Thread - Explict Logic Transactions
>
>
> Please be more specific with your question.
> Tell us more about what you are doing.
> I also recommend you get an upgrade to IBO if you are on 4.0.
> I am soon to release 4.5 and we are at 4.3.
>
> Jason Wharton
>
>
> > -----Original Message-----
> > From: Vincenzo Scarpellino [mailto:vincenzoscarpellino@...]
> > Sent: Tuesday, November 02, 2004 4:57 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] Thread - Explict Logic Transactions
> >
> > Which is best mode in a thread to do an explicit transaction
> > with a RollBack when error occur ?
> >
> > procedure TEurStampaThread.Execute;
> > begin
> > PostMessage(Handle, WM_NULL, 0, 0);
> >
> > with FormStLGThread do
> > begin
> > QueryPNO.Open;
> > end
> > end;
>