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. ;)
--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
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/cacw6n4snnj+s_bn5hapy89e0vbq9f4whhsm0gwucvygbzbk...@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.
