I have defined a stored procedure to update a set of records. I have
been testing, passing an argument for the WHERE SQL part, but I get
an ISC ERROR MESSAGE: lock conflict on no wait transaction deadlock.
The stored procedure content is:
BEGIN
UPDATE PATRON SET ISACTIVE = 1 WHERE SCHOOL = :SCHOOL_ID ;
END
and my settings are: IB_Transaction3 has LockWait = False, Isolation
= tiCommitted.

The code which is causing the error is:

var
SAI: TIB_StoredProc;
begin
SAI := TIB_StoredProc.Create(nil);
result := false;
try
SAI.IB_Connection := cts_IBDatabase1;
SAI.IB_Transaction := IB_Transaction1;
SAI.StoredProcName := 'SP_SET_ALL_INACTIVE';
SAI.ParamNames.Add('SCHOOL_ID');
SAI.Prepared := true;
SAI.ParamByName('SCHOOL_ID').AsString := 'DEMO';
try
IB_Transaction3.StartTransaction;
SAI.ExecProc;
IB_Transaction3.PostAll;
IB_Transaction3.Commit;
result := true;

I shall be grateful for your help with this situation.
Regards,
Horacio C.