>>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 ...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only