Re: Can't update record
hi ,
i have try to put in a SQL statement
UPDATE timetable SET timeno=1,timemode ='G' WHERE DateIn='20040101' AND timefile='1-1' Limit 1
and it update sucessfully.
why this happen ?
and i have try to loop (567 * 3 times) this statement and pass in different timeno , timemode, datein and timefile parameter in C#,
it update partial of the records , and after some time , odbc will lost connection with MYSQL server . and show me an error msg "cant connect to localhost"
why this happen ?
i have configure the max connection to 100 .
addition information . i am using inodb table.
Subject
Written By
Posted
Re: Can't update record
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.