>
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
>
Yes it would, but I was just trying to illustrate a larger problem I had where I was forced to use UNIONs
