I don't see the relationship with the previous conversation. To start a new question, it is better to create a new thread. The reason is to reduce confusion for people searching for specific topics.
In this case, I don't know the answer to your question.
>Good Day Sir,
>
>I need help on creating an 'iif()' expression on my FILTER condition on one of my remote views (using SQL 2000 as database) and VFP8 as IDE.
>
>Heres my code SQL Code on the VFP Designer:
>
>&& --------------------------------------------
>WHERE Tblcalls.caseno = ( ?pvcaseno );
>AND IIF(?pvpatno=0,Tblcalls.patno>0,Tblcalls.patno=?pvpatno)
>&& --------------------------------------------
>
>When I execute this query the it returns a line of:
>Incorrect systax near '='
>
>I hope you can help out on this, thank you.
>
>Marlon Estrelon
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)