Message
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Miscellaneous
ID da thread:
00524388
ID da mensagem:
00524676
Views:
18
>>>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
Responder
Mapa
View