Error message "Row cannot be located for updating"

2007-03-20 Thread Jonathan Trahair
- Original Message - From: Jonathan Trahair To: MySQL General Sent: Monday, March 19, 2007 11:10 AM Subject: Error message "Row cannot be located for updating" Hi Everyone I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I save them, and in a l

Error message "Row cannot be located for updating"

2007-03-19 Thread Jonathan Trahair
I should add, of course all the other items (re-)save perfectly, there is nothing about that actual record which is different. MySQL 5.0.27 WinXP Set mconn = New ADODB.Connection mconn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & "SERVER=" & mstrServerName & ";" & " DATABASE=" & mstr

Error message "Row cannot be located for updating"

2007-03-19 Thread Jonathan Trahair
Hi Everyone I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I save them, and in a large order (25 or more) there will be at least one which causes an error "Row cannot be located for updating. Some values may have been changed since it was last read." The values looked