update failed. Found 0 records

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
BRUNO
Posts: 6
Joined: Sun 11 May 2008 05:32

update failed. Found 0 records

Post by BRUNO » Sun 11 May 2008 05:44

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

BRUNO
Posts: 6
Joined: Sun 11 May 2008 05:32

update failed. Found 0 records

Post by BRUNO » Sun 11 May 2008 18:53

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

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Mon 12 May 2008 10:49

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.

BRUNO
Posts: 6
Joined: Sun 11 May 2008 05:32

Problem solved :)

Post by BRUNO » Mon 12 May 2008 11:12

Problem solved, thank you a lot
Pedro :D

Post Reply