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