Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized Views and 'Like'
Message
From
14/08/1997 12:08:11
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00044656
Message ID:
00044658
Views:
38
>I am creating a parameterized view. One of the parameters in this view is 'dbfname LIKE ?vp_dbfname. I thought this would allow me to have something similar to the 'contained in' operator ($). So, for example, if vp_dbfname = "A" then all dbfname's with 'A' in them would be pulled. The problem I am having is that no data is being pulled. The If I just use = instead of LIKE it works fine. I'm probably missing something.

The idea of 'LIKE'is to use wildcards (percent sign and underscore). E.g. if you want to retrieve all records started with "A", then vp_dbfname="A%". For records containing "A", you use construction vp_dbfname="%A%", etc.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform