Information générale
Catégorie:
Codage, syntaxe et commandes
>>If cUsrFirstChoice = 'Toolkit', then this works:
>>
>> where ?cUsrFirstChoice $ cTitle
>>
>>But if cUsrFirstChoice = 'Toolkit' and cUsrSecondChoice = ''
>>then this returns no records:
>> where ?cUsrFirstChoice $ cTitle
>> and ?cUsrSecondChoice $ Subtitle
>cUsrFirstChoice = "%" + lcYourVariable1 + "%"
>cUsrSecondChoice = "%" + lcYourVariable2 + "%"
>... where cTile like ?cUsrFirstChoice and SubTitle like ?cUsrSecondChoice
>Of course you do not have to precede the variable with a percent sign if your search is to start at the beginning of the field.
I can only get your first example to run if it's lcYourVariable not ?lcYourVariable, which is a requirement (I think) for Parameterized Views. I am trying to build a P-View giving VFP a substring to search instead of a standard "read left-to-right" search.
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