Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Running SQL Script (with GO commands) from VFP
Message
From
16/02/2018 22:01:37
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01658170
Message ID:
01658184
Views:
74
>>Just create a loop (DO WHILE) to split (STREXTRACT) your script in several parts where the word GO is the delimiter and execute the parts individually.
>>
>>Walter,
>
>Ok, I'll go with two separate scripts then.

The trouble is on SQL side - some commands simply have to be the first in a batch, can't be in the middle. It's a shortcoming of the parser and the syntax it allows, which Microsoft hasn't fixed yet, so I guess they never will.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform