🚀 go-pugleaf

Hello all.

I am having an ADO problem in the guise of frequent EOleExceptions with
message 'Row
cannot be located for updating. Some values may have been changed since it
was last read'.

I've narrowed the problem to the fact that the default for AdoExpress
datasets is to locate the record to update on all field values
(adCriteriaUpdCols). So if you change a row in
one dataset all the field values no longer match when you try to update it
from the second dataset. That is why I keep getting the fail messages.  I've
also seen the problem even
if there is only one dataset open!!

To solve this problem, I have to set the 'Update Criteria' dynamic property
to adCriteriaKey, which tells the dataset to use only the Primary Key to
locate the record.

In Delpi, this is done as follows:

ADODataSet1.Properties['Update Criteria'].value :=adCriteriaKey;

My problem is working out how to implement the above line in C++.

Any help in this matter will be much appreciated.

Ian.