Hi Francesco,

IF sqlexec(nhandle,"insert into mytable (list of fields) select list of fields from othertable") < 1
   AERROR(aaa)
   DISPLAY MEMO LIKE aaa
ENDIF

MartinJ

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