>>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
Thanks for all your help ...
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