Please don't use NIL as a value in the constructor when instantiating IBO
objects. Use a TIB_Session or the TIB_Connection component as the owner.

As for your question, I don't know what the problem is. You may need to set
the StoredProcHasDML property to true.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: <hcarvajalsy@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, December 11, 2002 4:50 PM
Subject: [IBO] lock conflict on no wait transaction deadlock


> 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.
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>