Executing a Stored Procedure from VFP 6 1

[LeonelSanchezJr]

What is the syntax to execute a SQL 2000 Stored Procedure from within Visual FoxPro?

Will the result be available in the Data Session like the regular data is?

 

[paulhuts]

Try this..
Executes the 'sp_tables' stored procedure and retuns data to the cursor 'cResults'

ConnString = "DRIVER=SQL Server;SERVER=[Server Name];UID=;PWD=;DATABASE=[Database Name]"

Handle = SQLSTRINGCONNECT(ConnectionString)

SQLEXEC(Handle, 'sp_tables', 'cResults')

 

[paulhuts]

That should of course be

ConnString = "DRIVER=SQL Server;SERVER=[Server Name];UID=;PWD=;DATABASE=[Database Name]"

Handle = SQLSTRINGCONNECT(ConnString)

SQLEXEC(Handle, 'sp_tables', 'cResults')