Alaska Software Inc. - SET FILTER Error
Username: Password:
AuthorTopic: SET FILTER Error
Jacob JohnSET 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 JohnRe: 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