>I am using the following code
>
>
>gnConnHandle = conector handle
>get data.. into array myarray
>*- INSERTING DATA TO THE ACCESS TABLE
>SEQSTRX = 'INSERT INTO merchant FROM ARRAY myarray'
>=SQLPREPARE(gnConnHandle,SEQSTRX)
>=SQLEXEC(gnConnHandle,SEQSTRX)
>*- END
>
>and nothing happens, I do connect to the database
>and create views with it and now I want to update it
>any help in what I am doing wrong??
>
>mark
Mark,
I just verified the following code works with Access
SqlStr='insert into table (fld1, fld2) values (?array[i,1], ?array[i,2])'
FOR i = 1 to 2
=sqlexec(handle, SqlStr)
ENDFOR
No need for an SQLPREPARE since SQLEXEC will handle it
-Tom
-TomC