>>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
>

Aerror return: conectivity error ORA-9926 missing VALUES keyword. Othertable is a select of mytable with no record. I insert some values in the new record and launch the statement.
What else could I do?