Re: Record not found or changed by another user


Yes I'm using a clientdataset connected to a datasetprovider which relies on a adodataset. The commandText of the adodataset is:
Select * From [Table] Where ID=[Integer].
My table has integer, real, datetime, varchar and one boolean field. The primary key is integer.
When first trying to applyupdates nothing happened. Then I tried the Action := HandleReconcileError(DataSet, UpdateKind, E); which displays the error. The changed field and values are correct.





"Bill Todd" <no@xxxxxx> wrote:
SKaziolas wrote:


Hi,
I'm using MSSQL2000 and Delhi 7 Enterprise. In a specific table of my
application when I try to ApplyUpdates I get the following message:
Record not found or changed by another user I know this is a Known
issue but I cannot a solution. And it happens only to a specific
table. The dataset on which dataprovider relies on is adodataset. I
can't notice any strange thing on this table.

Any ideas?

Are you using a ClientDataSet?

Does the WHERE clause of the UPDATE statement include a datetime field?

--
Bill Todd (TeamB)

.