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