mySQL does not support ADO???

From: <kelvinq415@xxxxxxxxx>
To:   win32@xxxxxxxxxxxxxxx
Subject: [mySQL VS6 C++ ADO myODBC Multiple Updates
fail]

Description:
        1) change a field in an ADO recordset           
27Feb03
        2) do a recordset->Update()
        3) repeat 1 & 2 get this error:
        
Code = 80040e38 Hex  WCode = 3128 Decimal Meaning =
IDispatch error #3128  Source = Microsoft Cursor
Engine  Description = Row cannot be located for
updating. Some values may have been changed since it
was last read.
        [p MDAC 2.7    cursor client]
        
        nb If I put multiple recordset->Update()
statements immediately after the 1st
        there is no error.
        So the problem is because some data (non key)
is changed  ( double, not varchar data)

How-To-Repeat:
        repeat steps 1 & 2 above
        sometimes I can do 2 or 3 change+Update before error
        see
http://www.devshed.com/Server_Side/MySQL/ODBC/comments/990105999/1000313305/1000314956/349238212
        for people having various Update problems in VB last
year

Fix:
        some forums with similar VB problems suggest:
"abandon ADO and use SQL commands"
        This is not a "fix" for ADO.   

Synopsis:       ADO update fails on some iteration 
Submitter-Id:   <submitter ID >
Originator:     C Skinner
Organization:   RewardTech
MySQL support:  none
Severity:       critical
Priority:       high 
Category:       [mysqld, mysql client, C
Class:          [ sw-bug | doc-bug | change-request | support
]
Release:        mysql-3.23.38

Exectutable:   [mysqld, mysqld-opt]
Environment:   Pent3
System:        <Win98>
Compiler:      VC++ 6.0
Architecture:  i 
 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10630@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.