>Thanks for your help Tom, now is there a way to loop thru the array and put the
>values in , EXAMPLE something like:
>
>INSERT INTO MERCHANT VALUES(FOR I TO LENARRAY;ARRAY(I)) OR
>I HAVE TO WRITE EVERY SINGLE ONE

Sure... you can build the select string into a variable by looping throught the array....

lcSqlString = "INSERT INTO MERCHANT VALUES ("

for i = 1 to alen(MyArray)
lcSqlString = lcSqlString + " '"+MyArray[i]+"' "
if i < alen(MyArray)
lcSqlString = lcSqlString + ","
endif
next i
lcSqlString = lcSqlString+")"

*** I would view the lcSqlString here to make sure it is right.
* but the above is the basic idea.

BOb