Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro substitution on parameterized view in VFP 8 don't
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00812113
Message ID:
00812160
Views:
25
>>We have worked in previous VFP versions with macro sustitution in parametrized views as:
>>>create sql view ... as select ... where &?mycondition ...
>>>This is not working on VFP 8. Have we losed it forever?
>
>>Try it without the question mark
>
>create sql view ... as select ... where &mycondition
>
>That isn't the point, Alex: if he does it that way, he creates the view statically. If he includes the parameter marker, he can substitute the condition at runtime.


I misread the question. You are correct!


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Reply
Map
View

Click here to load this message in the networking platform