Hi,

I have a IB_StoredProc to update and a IBOQuery to select and report data. It is isolated from others concurrency update and doesn't perform any update with new data, instead IBOQuery select every update done after it was open. I close and open again the connection so I can see concurrency updates, so work fine.


IBOTransaction2.Isolation:= tiConcurrency;
IBOTransaction2.RecordVersion:= True;
IBOTransaction2.LockWait:= False;

IBOConnect1.Connected:= False;;

IBOTransaction2.StartTransaction;
try
IB_SPUpdateData.ExecProc;
IBOTransaction2.Commit;
except
IBOTransaction2.Rollback;
raise;
end;

IBOTransaction2.StartTransaction;
try
IBOQueryReportData.Open;
IBOTransaction2.Commit;
except
IBOTransaction2.Rollback;
raise;
end;



--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Vuoi dimagrire oppure aumentare la massa muscolare o donare tonicità alla tua pelle? Qualunque sia il tuo obiettivo Oliviero.it ti propone dei pacchetti integratori personalizzati.
*
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid(47&d=6-12

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