Yes, SET FILTER always need to use macro substitution &filter_expr! Using SQL is also a better solution usually, depending how you move the record pointer.
On Wed, May 15, 2019 at 4:55 PM Johan Nel <johan....@xsinet.co.za> wrote: > > I realize I am not a VFP guy, but would the following not work? In > Clipper/VO this will work. > > set filter to &(filter() + " and empty(wfccccd)") -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAGv=MJDCYXDjc_=dihux2x0g+teygsuzqxukmy-uwzzc5kv...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.