General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only