Subject RE: [IBO] Thread - Explict Logic Transactions
Author Jason Wharton
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


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