Information générale
Titre:
How do I return results from a SQL Server stored procedure?
I need to know how to initially call a stored procedure in SQL and then how to return the results back to the VFP calling program as a cursor, array or variable (depending on the results of the s.p.). As an example, I've created a stored procedure named "spCountryList" in SQL Server's NorthWind database using the following syntax:
CREATE PROCEDURE "spCountryList" @cCountry char(20) AS
select * from customers where country = @cCountry
This should return the records from the customers table when a country is specified (i.e. "UK" will be captured in VFP as cCountry and then passed to the stored procedure as @cCountry. All the records which have "UK" in the country field will then be returned).
Thanks in advance,
Patrick
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement