I am getting this error message in VB6 with MySQL
-2147217864 Row cannot be located for updating. Some values may have been changed since it was last read.
I've opened recordset and change some fields . Then I tried to update recordset and had the error message
Set rsCt = New Recordset
rsCt.CursorLocation = adUseClient
rsCt.open SQLstring, mConn, adOpenStatic, adLockOptimistic
rsCt!OrderNumber = pbOrderNumber
rsCt!CustomerID = custID
rsCt.Update
I spent several hours searching for a solution. Changed primary keys in my tables,used different options in rsCt.Open . And eventually found a small message on forum.mysql.com
Open properties fo your DNS (Windows XP: Control Panel->Administrative Tools->Data Sources) and find option Return Matching Rows (turn it on).
Also, you can do this under connection string specity parameter OPTION=2.
This should work...
Osman :D
I added to my connection string option=2
ConnectionString = "driver={MySQL ODBC 5.1 Driver};option=2,server=" & mySqlIP & ";uid=" & usr_id & ";pwd=" & pass & ";database=" & Database
Finally the problem is solved. Thanks Osman!!!
Subscribe to:
Post Comments (Atom)
Labels
- accounting (1)
- accounting software (1)
- adjusting (1)
- ASP.Net 2.0 (2)
- barcode scanner (1)
- Blog (1)
- classical music (1)
- clothing software (1)
- Excel (1)
- fashion clothes (1)
- free invoice template (1)
- GAE (1)
- Horowitz (1)
- HTML (1)
- HTTPS (1)
- import Excel file (1)
- inventory (2)
- inventory software (1)
- inventory system (6)
- inventory system web based software ASP.Net (1)
- invoice (1)
- meta tag (1)
- mobile wireless inventory software (3)
- MS SQL (1)
- multi location (1)
- music pianist (1)
- music software (1)
- online (1)
- osCommerce (1)
- pen and paper (1)
- physical counting (1)
- piano (1)
- point of sale (1)
- query (1)
- receipt (1)
- reorder point (1)
- software (1)
- system (1)
- warehouse (1)
- warehouse management (1)
- web store (1)
- XML (2)
Posts
Official Illinois Bankruptcy Records
ReplyDeletehttps://www.bankruptcylive.com/records/il-illinoisbankruptcyrecords/
Obtain copy of Official Illinois Bankruptcy documents, Bankruptcy discharge papers $9.99, bankruptcy creditors listing $19.99 and complete file for $29.99 at lowest cost on web.
Thanks for the tips on inventory control systems. I've had the same problem, so I'll have to see if that works. Huge thanks.
ReplyDeleteWhether or not you are getting a lawyer to help you, you need to know what you are doing in your bankruptcy case so you don’t get burned.
ReplyDeletecalifornia bankruptcy