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
I may be mistaken here, but, off the top of my head, wouldn't this query do the job?
SELECT ICASE(vendno = '000463', 'A', vendno = '000687', 'D', ' ') AS MyField, vv.* ;
FROM \pro50\apdata\apvend18 vv ;
WHERE INLIST(vv.vendno, '000463', '000687')
INTO CURSOR zzzz
