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:
01439548
Views:
63
>Hi all
>
>How can I execute a bunch of SQL statements in a SQL scrupt file from within VFP using SQLEXEC or some other way?
>
>Your advice much appreciated.
>
>Thanks & Best Regards

EXEC. If the script file is a stored procedure, the command you pass to SQL Server from VFP is:

SQLEXEC (lnConn, 'EXEC sp_SomeStoredProcedure ' )

Include parameters in parentheses at the end of the passed string if the SP expects any. You must have obtained connection handle lnConn previously, as in any other SQLEXEC command.
Previous
Reply
Map
View

Click here to load this message in the networking platform