Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO and updating the recordset

Status
Not open for further replies.
garwain

garwain

Programmer
Joined
Jan 30, 2002
Messages
461
Location
CA
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?
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sysmatics
  • Locked
  • Question Question
how to add an image on the selected field in a dbgrid in Delphi 7
Replies
0
Views
980
sysmatics
sysmatics
delphi2024
  • Locked
  • Question Question
delphi xe8 Pls help copy the bold richedit1.text goin to edit1.text
Replies
1
Views
956
delphi2024
delphi2024
WolfstarUA
  • Locked
  • Question Question
Filtering AdoTable + dbrichedit
Replies
1
Views
552
DjangMan
DjangMan
PeterTooo
  • Locked
  • Question Question
REST and No mapping for the Unicode character exists
Replies
0
Views
936
PeterTooo
PeterTooo
akshin777
  • Locked
  • Question Question
Scan the local network
Replies
6
Views
1K
akshin777
akshin777

Part and Inventory Search

Sponsor

Back
Top