Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement