Can't update record
Posted by: Seng Kok Song
Date: January 06, 2005 10:58PM


i am using VS C# to develop an application which connect to MYSQL database.

currently i am using MYSQL ver 4.1 and Connector/ODBC 3.51 that allow me to connect to the database.

I am facing an update records prob with MYSQL ,
when i issue

myOdbcCommand.CommandText = UPDATE timetable SET timeno=1,timemode ='G' WHERE DateIn='20040101' AND timefile='1-1'

no records was update to the table and no error return to the connection too.
why this happen ? error on SQL syntax ? or is that i need to add limit = 1 to the commandtext ? or any solution for this prob ?

Options: ReplyQuote

Written By
Can't update record
January 06, 2005 10:58PM
January 06, 2005 11:19PM
January 07, 2005 04:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.