You cannot use an update query to add new records to a database, or to delete entire records from a database.
To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.
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.
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.
ADO, compared to the BDE, has taken a more practical approach to the problem.OLE DB provider 'MSDAORA' could not UPDATE table '[GASLC]..[SYSDBA].[SITEKEYS]'.The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.For more information, see Can't connect to [local] My SQL server.The following error is reported when using transactions: .I have installed Connector/ODBC on Windows x64 editions.