Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL, Views, and Macro Substitution
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Divers
Thread ID:
00921296
Message ID:
00921849
Vues:
26
>
>Just so I (and everyone else) understands, in VFP 9.0 (Beta) to have Views that use macro-substitution, you must follow these rules:
>
>1. You MUST put a "?" question mark on the front of your parameter, just like you did prior to VFP 8.0.
>

Correct.

>2. You MUST have defined a variable with the same name as your parameter PRIOR to defining the view (and it must be in scope).
>

Correct.

>3. The variable defined must be of type STRING and it must NOT be empty. It doesn't matter what is in the string, but it cannot be "" or " ".
>

I does matter what in the string, it should be possible to compile the statement after the macro-substitution is applied.

>4. Unfortunately, you still CANNOT use the much improved View/Query Designer when working with macro-substituted parameters (huge bummer), they must be created via code.
>

Even though it is possible to use macro-substitution in a local View, I believe local Views were not specifically designed to support this feature. This might explain why it is not documented and why it is not supported in the View Designer.

Thanks,
Aleksey.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform