Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL, Views, and Macro Substitution
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Miscellaneous
Thread ID:
00921296
Message ID:
00921849
Views:
25
>
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform