ADO and updating the recordset

[garwain]

I'm starting to receive errors "cannot locate row for updating" whenever I try to post my changes to a recordset.

How can I make the update occure based only on the primary key like using the updateMode property under BDE?

 

[TealWren]

What database are you using? I am not sure how you can mimic the BDE functionality, but I have seen that problem before.

We use SQL Server, and this was often caused by a record being saved with bit fields having no value. A database default for all bit fields can be useful in eliminating the problem.

Good luck!
TealWren