Re: mySQL does not support ADO???

Try using Recordset.Requery before update. This error occurs when you try to
update a field that was defined with a default value in mysql. For example,
if you assign not null constraint to a date field and update it from ADO
without setting a value, mysql converts it to default value on database
before commiting. Trying to update same record from ADO causes this error,
because ADO knows the record was changed by mysql.

----- Original Message -----
From: "Kelvin Kline" <kelvinq415@xxxxxxxxx>
To: <win32@xxxxxxxxxxxxxxx>
Sent: Thursday, February 27, 2003 6:44 AM
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-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.
>
>


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10631@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.