Can't update record
hi,
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 ?
Subject
Written By
Posted
Can't update record
January 06, 2005 10:58PM
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.