Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro substitution in sql views no longer possible
Message
 
To
14/01/2005 01:56:25
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00975746
Message ID:
00977074
Views:
60
>>Well, it was only needed to explicitly tell VFP that it must evaluate the cWhere during requering the view at runtime.

If you did not include the ? and and variable cWhere does exist during creation of the view, it would just evaluate the cwhere at creation time (which of course leads to a fixed where definition), while we want one where cWhere is evaluated at design [G: Guess you mean RUN here!] time.
<<
Ahh, thanks!
G
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform