Subject Re: [IBO] Record not located to delete
Author Helen Borrie
At 08:52 AM 04-10-02 +0200, you wrote:
>I have a query which I populate with the query "Select * from Funds" with no
>mastersource or keysource. The KeyLinks is "Funds.FundId". I open the
>dataset, but get the following error when trying to delete a record "Record
>not located to delete". Any idea why? It seems to be a straight forward
>request. If I use DeleteSQL string, it works. The error seems to hint at
>"not records affected??

...or more than one candidate record.

Is FundID on its own the primary key, or otherwise unique in the
table? Dataset deletes and updates are searched, that is, they operate on
the single record currently pointed to by the buffer cursor. Perhaps your
DeleteSQL string works because it is performing a positioned update, that
is, deleting all records in the table where FundID = :fundID...

If FundID is part of a composite PK, then you must include all of the PK
columns in KeyLinks.