>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


lcCountry="UK"
= SQLEXEC (gnConnHandle, "sp_CountryList ?lcCountry", "curCountry")

HTH
Oleg