I'm using: My SQL 4.1.11-nt-max My SQL Client 5.0.0 My ODBC 3.51.11-2 MDAC 2.8/2.7 VB6 Windows XP SP2 Error Message: Row cannot be located for updating. Connection String = "Provider=MSDASQL.1; User Name=root; Password=password; Extended Properties=""driver=; DATABASE=test; OPTION=3; PORT=0; SERVER=localhost""" cn.
Some values may have been changed since it was last read.
Connection String = "DRIVER=;" & "SERVER=" & mstr Server Name & ";" & " DATABASE=" & mstr This Database & ";" & "UID=root; PWD=" & mstr This Password & "; OPTION=3" mconn.
Description: A float column with a long decimal digit value that where inserted from My SQL Query Browser or My SQL Command Line, cannot be updated/modified using VB6 and ADO 2.7/2.8.
Now, eventhough I know this I still can't get it to work.
thanks for the comments/suggestion you can give me." id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="745276" / Hi to all again, I tested the vb codes again and found out that the error is when I assign a value coming from a textfield back to the recordset field which has a data type of double(12,2) in the database.
How to repeat: Create a table with float not null column mysql insert into t1(f) values(144.977477477477); Query OK, 1 row affected (0.02 sec) ** use the same value: 144.977477477477 Create a project in VB6 w/ a Form & Command button: Private Sub Command1_Click() Dim cn As New ADODB.
Open("select * from t1 where id=1", cn, ad Open Static, ad Lock Optimistic) .
Description: When I try to update a record but there are no changes in the record the update fails with the following error text: "Row cannot be located for updating. Update() End With If the information in the database is the same as what's in the update then the error occurs. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Left on it's own, *Access* forms rather insane update queries depending on *all* fields values, timestamps and who knows what.
Some values may have been changed since it was last read." As far as I can see there are two work-arounds: 1. First check if there are changes in the record How to repeat: rs. Conn, Cursor Type Open Keyset, Lock Type Lock Pessimistic) With rs . Same problem here, My SQL ODBC Driver 5.1 Access 2007, vba code .update doesn't work when the value is already in the table. Please try to tell Access how to form UPDATE queries as described above: rs Customers. Value = ad Criteria Key and catch any error it might throw.
thanks for the help, I really appreciate it." id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="742834" / shuggi_e, yes, i used My SQLQuery Brower to retrieve the data and can even update it.
Normally, record values are assigned to textboxes for edit then assign the values back to the fields for updating, is it possible that that causes the error? out that the error is when I assign a value coming from a textfield back to the recordset field which has a data type of double(12,2) in the database.
Open "SELECT * FROM Customers", cn NWind, _ ad Open Static, ad Lock Optimistic, ad Cmd Text rs Customers. No feedback was provided for this bug for over a month, so it is being suspended automatically.