Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using parentheses in view designer
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00524388
Message ID:
00524661
Views:
15
>>WHERE Empmaster.deptcd == ?cDept AND INLIST(Empmaster.termdate, {}, DATE())
>>
>>or
>>
>>WHERE Empmaster.deptcd == ?cDept AND Empmaster.termdate IN ( {}, DATE() )
>>
>>The {} means empty date
>
>That won't work Mark... he needs Empmaster.termdate > DATE()

I caught that right after posting, and posted a supplemental reply to that affect.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform