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:
00921810
Views:
33
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform