RE: ADO and MySQL Error - Michael Avila - com.mysql.lists.win32

12 messages in com.mysql.lists.win32RE: ADO and MySQL Error

From	Sent On	Attachments
Christian Surya	16 Dec 2004 01:08
Daniel da Veiga	16 Dec 2004 05:39
Peter Harvey	16 Dec 2004 08:03
Michael Avila	16 Dec 2004 14:48
Christian Surya	16 Dec 2004 18:18
Peter Harvey	16 Dec 2004 22:12
Christian Surya	16 Dec 2004 23:34
Ruben Edna	16 Dec 2004 23:56
Charles Metcalfe	17 Dec 2004 00:34
HMax	17 Dec 2004 01:07
Christian Surya	17 Dec 2004 01:26
Bernard LEFEUVRE	24 Dec 2004 02:32

Subject:	RE: ADO and MySQL Error
From:	Michael Avila (mav...@mich.com)
Date:	12/16/2004 02:48:10 PM
List:	com.mysql.lists.win32

Hi,

I was getting that all of the time under the last few MySQL beta and production releases (I believe all the ones I used were 4.x.x). Probably more of an ODBC problem that MySQL but maybe not. The key to getting the error is that you must have more than one record in the recordset for that to happen. If you have only the one record it will work. I gave up and coded it differently in order to get it to work. I don't have the code in front of me right now to post what I did. I'd love to see a good workaround or if it really is a bug, to be fixed ASAP. I consider it a critical issue but did not have time to research and report it as a potential bug.

Mike

-----Original Message----- From: Christian Surya [mailto:csur...@gmail.com] Sent: Thursday, December 16, 2004 4:09 AM To: win...@lists.mysql.com; myo...@lists.mysql.com Subject: ADO and MySQL Error

Hi, I have a problem with VB6 SP6, ADO2.8 and MySQL database version 4.1.7 and ODBC 3.51.10. i use Update function of the recordset and it raise error when update the database. the error is "Query-based update failed because the row to update could not be found." These error only occur if i want update data not insert.and the error source is from ODBC engine. anyone can help me?

thanks in advance chris