BorlandTalk.com

Terry · Guest

I have a master detail relationship set up on a notebook. first tab is the
master record and the other tabs display the detail table information for
update and insert.

when I attempt to delete a detail record. by doing a
DataSource.dataset.delete where the datasource points to an adodataset, i
get the following error
EOleexception... Row cannot be located for updating. Some values may have
changed since it was last read.

If I tab through the detail records, the deleted record is still there. If
I change the master record , then go back to the one in question, the detail
record is gone.

The deleted record appears to still be in the recordset for the detail table
( until I change the master record ) . What needs to be done to get rid of
the error, and the record?