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
>