|Subject||RE: [firebird-support] Steps to Set Wait/No Wait Transaction|
>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.