RE: mySQL does not support ADO???

I happily write VB apps using MySQL via the MyVBQL library. I though I would
miss ADO but I seem to be able to do everything I want using direct SQL plus
a few utility routines to handle populating forms etc. ADO is a large and
helpful bit of software useful when you are getting started but is a prop
you rarely need once you are more experienced.

After all, if your data is on an SQL server then all interactions have to
boil down to SQL in the end, whether you or Microsoft do the boiling down!

John Bonnett

-----Original Message-----
From: Kelvin Kline [mailto:kelvinq415@xxxxxxxxx]
Sent: Thursday, 27 February 2003 3:14 PM
To: win32@xxxxxxxxxxxxxxx
Subject: 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-thread10638@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.