Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two filters
Message
 
To
30/04/2001 13:00:54
Ben Dekker
Dekker Soft & Hardware
Axel, Netherlands
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00501613
Message ID:
00501651
Views:
17
>>>Hi All
>>>
>>>Can I use two filters something like this?
>>>
>>>use customer
>>>set filter to country = "USA" .and. name="John"
>>>
>>
>>That works, yes, but since the syntax is (as you correctly have it)
>>Set Filter To Expression,
>>your example is actually one filter because country="USA" and name="JOHN" is the expression.
>>Make sense?
>
>OK, but my filter is actual
>
>
>    set filter to periode = jaar.periode .and. datum = cdow(dDatum)
>
>
>jaar.periode is numeric and dDatum is a date
>I got the error Operator/Operand type mismatch

Did you really mean cdow() or did you want dtoc()? If it is dtoc(), this assumes datum is a string. If you want to compare a date field with a date variable, then it's just plain datum=dDatum.

HTH
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Reply
Map
View

Click here to load this message in the networking platform