Hi Sergey,

what if suppose i have 2 tables: each containing records that are not related to the other. In native programming, i should scan the first table using engrcode as the param and insert it to a cursor then scan the second table for the param engrcode and insert the records to the same cursor. I don't know how to do this using SQLEXEC()


table1(fields)
>> engrcode
>> dispatchno

table2(fields)
>> engrcode
>> dispatchno
>> engrname

thanks again....