General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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