Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Running SQL Script
Message
 
 
À
17/12/2009 00:40:34
Hong Yew
People Quest
Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01439526
Message ID:
01439548
Vues:
62
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform