Gene If you would have used a select..where.. into cursor curTemp from myTable into curosr myCursor than your next select statement could be select...where...from myCursor into cursor Temp2 you are done. easy quick and dirty. Regards, Koen
Op zo 19 mei 2019 om 16:29 schreef Man-wai Chang changmw@gmail.com
You can just watch the value of variable f. A valid filter expression stored in variable f will not produce error.
What are you trying to do when you said "...would prefer just one statement.... in the heat of debugging"?
On Wed, May 15, 2019 at 6:46 AM Gene Wirchenko gene@shaw.ca wrote:
I do know that I can do f=filter()+" and empty(wfccccd)" set filter to &fbut in the heat of debugging, I would prefer just one statement.
Is there a way to extend a filter in one statement withoutretyping the current filter expression?
-- .~. 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!
[excessive quoting removed by server]