>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

don't know, but according to the docs, you don't send the SQL in the sqlexec() after you have prepared the SQL... so, your code should be...

*- INSERTING DATA TO THE ACCESS TABLE
SEQSTRX = 'INSERT INTO merchant FROM ARRAY myarray'
=SQLPREPARE(gnConnHandle,SEQSTRX)
=SQLEXEC(gnConnHandle)
*- END


Also, are you using manual transactions in your connection? If so, you have to commit this.

SQLCOMMIT( gnConnHandle )

BOb