I have a problem while trying to update my database. I receive the above errormessage.

This is my situation:

ServerApp with OracleDataset with a TDatasetprovider linked to it. The UpdateMode of this provider is set to upWhereKeyOnly.

ClientApp using a TSocketConnection to attach to the server. A TClientdataset is linked to TDatasetprovider of the server. There's a persistent fieldobject 'ID' of which Providerflags pfInkey set.

Any time I try to update the database I receive the above errormessage.

Anyone has a solution to this problem?

The pfInKey flag you mentioned is set in the TOracleDataSet field?

The pfInkey is set only in the TClientDataset of the clientapp.

I think I solved the problem:
I have used the UniqueFields-property of the TOracleDataset to identify the ID-field. It seems to work this way.

There's one thing I don't understand. The n-tier demo delivered with DOA does not use this UniqueFields-property.
With this demo updating is no problem. I checked all the properties in the demo and compared them to the properties in my project.
So there must be another possible solution to the problem. Any idea?

You need to set pfInKey for the ID field in the TOracleDataSet instead of the TClientDataSet.

Thanks it works.