You can't do that. Your OtherTable is native VFP cursor and you can't insert it's records in SQL Backend. Check
How to make SQL Pass-Through cursor updatable FAQ #8153 to see how to do that.
>the error returned is very strange:'table or view does not exist' but it does! it is the STP with no records where I inserted new values. The steps are:
>1)select all fields from mytable into othertable. If no records, (it's my case) 2)I insert into othertable some or all values and 3)launch the statement you know. I tried to copy the structure and values to a different table and modify the statement with this new table, but it's the same error.
>Some new idea?
>Thanx in advance
>
>
>>>Hi all,
>>>this statement does not work: sqlexec(nhandle,"insert into mytable select * from othertable").
>>>Any suggest will be welcome
>>>Francesco
>>
>>Number and Type of fields in MyTable must match the number and type of fields in OtherTable. But you can always check WHY this not works:
>>
>>IF sqlexec(nhandle,"insert into mytable select * from othertable") < 1
>> AERROR(aaa)
>> DISPLAY MEMO LIKE aaa
>>ENDIF
>>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.