Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT Stored Procedure
Message
From
04/10/2005 20:42:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SPT Stored Procedure
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01056107
Message ID:
01056107
Views:
60
Hi.

isdone=sqlexec(handle,"exec sp_extractproducts","abc")

Using the above code to return a recordset into 'abc', from an SQL Server database does not seem to work.

Any ideas would be appreciated.

The stored procedure is as follows:

CREATE PROCEDURE sp_extractproducts AS
set nocount on
select * from soldproducts where qty>0
GO

Sincere thanks.
Mike Mayo
Next
Reply
Map
View

Click here to load this message in the networking platform