Update failed: Found 0 records
Posted: 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
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