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..