Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CREATE SQL VIEW Question
Message
From
24/06/2009 15:24:52
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01407899
Message ID:
01408210
Views:
28
Ok, Here's what I have been able to surmise


What i am doing is

Create SQL VIEW (lcViewName) as &lcView

lcView is on the order of 3900 bytes long.

Tried a bunch of different things and I think i may be blowing the macro parsing\substitution

What worked was this

lcCommand = "Create Sql View "+lcViewName+" as "+lcView
Execscript(lcView)

Interesting, Huh
Any Thoughts?
Joseph Gori
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform