Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Results Sets from Stored Procedures
Message
From
15/05/2007 12:59:42
Moacyr Zalcman
Independent Consultant
São Paulo, Brazil
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Results Sets from Stored Procedures
Miscellaneous
Thread ID:
01225649
Message ID:
01225649
Views:
66
When I call a stored procedure from Visual FoxPro it returns every result set to the client

CREATE PROCEDURE dbo.Teste
AS
BEGIN
select * from agenda
select * from pais
select getdate()
RETURN 1
END

It returns 3 result sets to the client. Is there a way to avoid this? I want to do the queries
I want to work with the data inside the procedure but I don't want the result sets back.

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform