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?