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