Hi, The use of 'Set Filter' in VFP is outdated. Nowadays we use Select....from...Where...into Regards, Koen
Op wo 15 mei 2019 om 10:55 schreef Johan Nel <[email protected]>: > 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)") > > On 2019/05/15 01:43, Ted Roche wrote: > > On Tue, May 14, 2019 at 6:46 PM Gene Wirchenko <[email protected]> wrote: > > > >> use cwkf > >> set filter to validto>={^2019.01.01} > >> count > >> browse > >> > >> I do know that I can do > >> f=filter()+" and empty(wfccccd)" > >> set filter to &f > >> but in the heat of debugging, I would prefer just one statement. > >> > >> Is there a way to extend a filter in one statement without > >> retyping the current filter expression? > >> > > No, SET FILTER is an ancient command that doesn't seem to accept anything > > other than the literal expression inline. Your two-line macro expansion > is > > likely the fastest and simplest. > > > > But there are lots of workarounds: > > 1. Add the filter on to the commands: > > count for empty(wfccccd) > > browse for empty(wfccccd) > > 2. Use SQL: > > SELECT Count(*) FROM cwkf WHERE EVALUATE(FILTER("cwkf")) AND > empty(wfccccd) > > SELECT * FROM cwkf WHERE EVALUATE(FILTER("cwkf")) AND empty(wfccccd) > > 3. Up-arrow twice and add the filter expression to the end of the > filter. ;) > > > > > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/CACUu1St8=lgmqckozeqojyj-a2vkz44l7zv29ckr8wmqmlv...@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.
