>>Hi All:
>>
>>The following code does not work.
>>
>>
>>SELECT 'A', * FROM \pro50\apdata\apvend18 vv ;
>>WHERE vendno = '000463' ;
>>INTO CURSOR curAdds
>>
>>SELECT 'D', * FROM \pro50\apdata\apvend18 vv ;
>>WHERE vendno = '000687' ;
>>INTO CURSOR curDeletes
>>
>>SELECT * ;
>>FROM curAdds;
>>UNION ;
>>sele * ;
>>FROM curDeletes;
>>INTO CURSOR zzzz
>>
>>
>>
>>Getting the following error:
>>
>>
>>Operation is invalid for a memo, blob, general or picture field
>>
>>
>>It seems that it's the UNION that's causing the problem, since the SQL works up until then.
>>
>>Thanks,
>>
>>Yossi
>
>Yes, you can not use UNION with memo fields as UNION tries to perform a distinct operation. You may try UNION ALL if you don't need a result with distinct entries. You can also try to insert deleted values into the first cursor if you create it with readwrite option.
Naomi,
Thanks a lot! I did not need the DISTINCT, so I just added ALL and it worked.