Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter question
Message
From
31/03/2000 19:11:32
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00353657
Message ID:
00353729
Views:
16
I don't understand the difference between the first option and the second line of the second option. In both cases, lcCustno is a string, so what do the "[" and "]" do in the first case?

Thanks,

Michelle



>If custno is a string, and cannot legally contain [ or ] as part of the string, so that they can be used as safe delimiters:
>
>SET FILTER TO custno = [&lcCustno]
>
>If custno is a numeric:
>
>lcCustNo = STR(nCustNoToTest)
>SET FILTER TO custno = &lcCustno
>
>In these cases the filter contains a literal created via macroexpansion, and literals do not change because of scope issues. In both cases, the content of lcCustNo must be a string.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform