General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
You could put
"(Empmaster.termdate =CTOD("") OR Empmaster.termdate > DATE())" in the expression field and set the Criteria to "=" and Example to ".T.". We found that you can't input a "." as the first character in the Example field but you can enter any other character first and then go back and delete the first character after inputing the ".T.". I don't think this is an optimizable expression.
HTH,
Dan
>Is it possible to use parentheses in the local view designer? I have a WHERE clause that reads:
>
>WHERE Empmaster.deptcd == ?cDept AND Empmaster.termdate =CTOD("") OR Empmaster.termdate > DATE()
>
>I need it to read:
>
>WHERE Empmaster.deptcd == ?cDept AND (Empmaster.termdate =CTOD("") OR Empmaster.termdate > DATE())
Previous
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