Re: Filtering Oddity

At 16:43 2019-05-14, Ted Roche tedroche@gmail.com wrote:

On Tue, May 14, 2019 at 6:46 PM Gene Wirchenko gene@shaw.ca 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.

I posted about this problem to foxite.com as well. Yuri Rubinov suggested EXECSCRIPT("SET FILTER TO "+FILTER()+" and empty(wfccccd)") which works.

[snip]

Sincerely,

Gene Wirchenko