Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Running SQL Script
Message
 
 
To
17/12/2009 00:40:34
Hong Yew
People Quest
Malaysia
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01439526
Message ID:
01439545
Views:
68
There are a few ways you can do that (in no particular order)
  • SQLEXEC(lnConn, FILETOSTR(lcScripFileName)). Keep in mind that 'GO' statement isn't a part of T-SQL. If the batch includes 'GO' statements, you'll have to parse it and send each one separatelly.
  • SqlCmd command line utility
  • SQL DMO/SMO

    >
    >How can I execute a bunch of SQL statements in a SQL script file from within VFP using SQLEXEC or some other way?
    >
    --sb--
  • Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform