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:
00921810
Vues:
35
OK, that worked! THANK YOU Aleksey! You saved me hours of headache!!!

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.

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).

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 " ".

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.

Please correct me Aleksey if I got any of this wrong.

Thanks Again,
Paul
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform