|Subject||Re: [firebird-support] Steps to Set Wait/No Wait Transaction|
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]" <email@example.com> wrote:
>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;
//Have Insert SQL Execution here
except on E: Exception do
FireDac would be quite similar.