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:
00524676
Views:
16
>>>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.

OK... but you forwarded the first email to me and not the supplemental... I only replied because you had sent the email to me.
Brien R. Givens

Brampwood Systems
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform