Devart Forums

Hi:
I have the next error when execute the procedure "ApplyUpdate"
"update failed. Found 0 records"

My TUniQuery Componente has the next Sql property:

select * from tbBids where Class=0
order by Fec

also it has the SqlDelete property:

execute procedure DeleteTbBids(:id_bid, 1 ) .

Any Ideas?
thank you

I am using firebird 2.0 database

the table has the folow Structure:

CREATE TABLE DEMO(
A Smallint NOT NULL,
B Varchar(20),
PRIMARY KEY (A)
)

and the Store procedure has the next source code:

ALTER PROCEDURE DELETEDEMO (
VAR Smallint )
AS
BEGIN
insert into X (A) values (1);
END

the error ocurrs when I try apply the changes "UniQuery1.ApplyUpdate" after of delete the record

thank you

There is no way to detect number of rows affected in InterBase when executing stored procedures. Please try to disable the StrictUpdate option of TUniQuery.

Problem solved, thank you a lot
Pedro