Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Two filters
Message
 
À
30/04/2001 13:00:54
Ben Dekker
Dekker Soft & Hardware
Axel, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00501613
Message ID:
00501651
Vues:
21
>>>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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform