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

Thanks a lot for the Idea, now what happens whenever you find a Numeric
value with decimals,, it will give you an error isn't it?
now how do you determine whether is a num value or not... Dohhh!! <-- ahead of time

mark