Errormessage 'Unable to find record. No key specified'

[molgev]

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?

 

[Marco Kalter]

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

 

[molgev]

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

 

[molgev]

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?

 

[Marco Kalter]

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

 

[molgev]

Thanks it works.