| Subject | Re: [firebird-support] Steps to Set Wait/No Wait Transaction |
|---|---|
| Author | Vishal Tiwari |
| Post date | 2017-01-13T06:08:19Z |
I am using TIBSQL, TIBDatabase and TIBTransaction components. This code is not fitting there.
Would you please provide me Firebird Tools Group mail ID?
On Friday, 13 January 2017 11:15 AM, "Maya Opperman maya@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
Hi Vishal,
>I need to understand how to set Wait/No Wait Transaction in firebird.
I think you mean in Delphi? Might be better to ask on the Firebird tools group, but I have replied below
the transaction locks particular rows in the table or it locks entire table?>Also I have one doubt that I when we start transaction through code as shown below,
I think you will be fine as long as you use generator to get your ID’s if you use auto-incremented numeric primary keys.
Delphi code snippet for FIBPlus would
be:
sqlMain.Transaction.TPBMode :=
tpbDefault;
sqlMain.Transaction.TRParams.Clear;
sqlMain.Transaction.TRParams.Add('read_committed');
sqlMain.Transaction.TRParams.Add('rec_version');
sqlMain.Transaction.TRParams.Params.Add('nowait');
//try
sqlMain.Transaction.StartTransaction;
try
//Have Insert SQL Execution here
sqlMain.Transaction.Commit;
except on E: Exception do
begin
sqlMain.Transaction.Rollback;
raise;
end;
end;
FireDac would be quite similar.
Cheers
Maya