>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
Précédent
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