Update failed: Found 0 records

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lt.col.blair
Posts: 1
Joined: Fri 10 Sep 2010 06:28

Update failed: Found 0 records

Post by lt.col.blair » Fri 10 Sep 2010 08:07

Hi,
I',m new to this forum and new to IBDAC.

I want to use an IBCQuery to read and write via stored procedures (if possible).

My idea is to read from a stored procedure:
select * from ReadRecords [where ...]

This procedure returns the Fields for my Dataset.
After editing the records are inserted or updated via a different stored procedure:
execute procedure WriteRecords(:Field1, ... , :FieldN)

The RefreshOptions are set to [roAfterInsert, roAfterUpdate] with ReturnParams set to TRUE.

When I post a record I get the message "Update failed: Found 0 records".

... What did I do wrong?

TIA

AndreyZ

Post by AndreyZ » Fri 10 Sep 2010 14:47

Hello,

Set the IBCQuery.Options.StrictUpdate option to False.

Post Reply