General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only