General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanx,
i have one more doubt.. I'm trying to update a Mysql database from this array..
FOR i=1 TO gncount
lctime=ttime[i]
SQLEXEC(lccon,"UPDATE mytab SET tdtime=?lctime WHERE tdtime='0000-00-00 00:00:00'")
next
I know this code is buggy because the tdtime field in the Mysql database is being set to one value only.. How can i update the field "tdtime" with successive values from the array??
The first 50 records in Mysql are set to 0000.. and i want to update them from the array(50 values in this array)
and thanx for that array fix..
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only