Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro substitution in sql views no longer possible
Message
From
23/02/2005 03:30:27
Walter Meester
HoogkarspelNetherlands
 
 
To
22/02/2005 22:23:15
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:
00989516
Views:
29
HI geoff,

Unfortunately it is not supported. IMO, something that the VFP team needs to address as it really is a cool feature.

Walter,


>Hi Sergey
>
>I know this works with local views but it was my understanding that it would work with remote views also. Unfortunately, when I try to create the remote view I get a syntax error.
>
>Is it not supported with remote views or do I have to do it differently?
>
>regards
>Geoff Scott
>
>>Doru,
>>
>>It still works in VFP9 but you have to code it differently:
>>
>>- The variable lcMacrotest has to be defined before view is created
>>- The variable lcMacrotest should be precceded by '?' in the view
>>
create sql view lvMacrotest as sele * from macrotest where &?lcMacrotest
>>
>>>The following worked in VFP 8, but it does not work in VFP 9
>>>
create table macrotest free (f1 c(10), f2 c(10))
>>>create database dbmacrotest
>>>create sql view lvMacrotest as sele * from macrotest where &lcMacrotest
>>>This was not documented, but it was nice. Macro was stored in the view expression as macro, and when the macro expression in scope changed, requery() expanded it.
>>>Too bad... :(
Previous
Reply
Map
View

Click here to load this message in the networking platform