Author | Topic: SET FILTER Error | |
---|---|---|
![]() | Jacob John | SET FILTER Error on Thu, 16 Jul 2020 19:53:40 +0530 Hi, When settiing the following filter, cFilter:="(FIELD04 >= Val('2000.00') .and. FIELD04 <= Val('3000'))" bFilter:=&("{ || " + cFilter + " }") Sele (cAlias) ; SET FILTER TO Eval(bFilter) getting an error "Syntex error in macro expression." But following is working without any problem cFilter:="(FIELD04 >= Val('2000.00'))" bFilter:=&("{ || " + cFilter + " }") Sele (cAlias) ; SET FILTER TO Eval(bFilter) Whats wrong with the first statement ? Any idea ? Regards Kiron |
![]() | Jacob John | Re: SET FILTER Error on Thu, 16 Jul 2020 20:01:06 +0530 Sorry. It was my mistake. It is working Kiron On Thu, 16 Jul 2020 19:53:40 +0530, Jacob John wrote: >Hi, > >When settiing the following filter, > > >cFilter:="(FIELD04 >= Val('2000.00') .and. FIELD04 <= Val('3000'))" >bFilter:=&("{ || " + cFilter + " }") >Sele (cAlias) ; SET FILTER TO Eval(bFilter) > >getting an error "Syntex error in macro expression." > > >But following is working without any problem > >cFilter:="(FIELD04 >= Val('2000.00'))" >bFilter:=&("{ || " + cFilter + " }") >Sele (cAlias) ; SET FILTER TO Eval(bFilter) > >Whats wrong with the first statement ? Any idea ? > >Regards >Kiron |