Re: Can't update record
Posted by: Seng Kok Song
Date: January 07, 2005 04:08AM

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.

Options: ReplyQuote

Written By
January 06, 2005 10:58PM
January 06, 2005 11:19PM
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.