Information générale
Catégorie:
Codage, syntaxe et commandes
Chris,
>>I had to do something similar. In the view use LIKE for the comparitor.
>>then when the user selects ALL pass in % for the value of the parameter.
>
>
>Explain for me what you mean by %. Is it a literal or are you referring
>to a wildcard operator? (My keys are integer)
>
Sorry, some of my old SQL slipped in there. Here is the snippet:
Actually % isn't used, but "" as shown below. The view in this sample would have a filter:
color_field LIKE ?lcColor
#DEFINE ALL_LOC "(All)"
lcColor = IIF(THISFORM.cboColors.VALUE = ALL_LOC, "", ALLTRIM(THISFORM.cboColors.VALUE))
REQUERY("your_view")
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement