Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create SQL View (embed variable) best way q
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01301700
Message ID:
01301754
Views:
11
>>Macro substitution sadly does not work and the string length is too long for concat process.
>>How would you create my view with my vars?
>
>text to lcSQLCmd textmerge noshow
> ... substitute all variables with <<var>>
>endtext
>
>then
>
>&lcSQLCmd
>
>Or if the length of lcSQLCmd exceeds 8K:
>
>execscript(lcSQLCmd)

Not working
lcSQLCmd variable does not exist at macro attempt
execscript is not an option in VFP6

I defined lcSQLCmd but the macro still fails.

What am I missing here?
Edgar L. Bolton, B.S. B.B.A.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform