Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filter question
Message
 
 
À
31/03/2000 19:05:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00353657
Message ID:
00353729
Vues:
17
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
Fil
Voir

Click here to load this message in the networking platform