>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement