Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Substring search with Parm View?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00170654
Message ID:
00171101
Views:
29
Here is what I do to solve this problem.
Create a table with a char 24 field named MyField.
Add a record with Append Blank.
In the command window:

? '' $ MyField && displays .F.
replace MyField with ''
? '' $ MyField && displays .F.

** If at first you don't succed ...
? empty(MyField) && displays .T.
? '' $ alltrim(MyField) && Holy cow! .F. again!
** ... live with it.

Now the question is why are you looking for ''?
If you are looking for empty field then try
? space(len(MyField)) $ MyField && displays .T.
or
? empty(MyFeld)

Good luck Steve.


>I am trying to build a Parameterized View, but I want to do a substring search with 3 parameters.
>
>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
>
>I was dinkering with macro expansion and the '%' but am coming up dry. Help?!
A moment of silence is our cosmic reset button.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform