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