>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
=SQLEXEC(lnConnHandle, 'Storprocname' + ' ' + 'parm1' + ', ' + 'parm2' + ', ' + ... + 'parmN', 'cursorname')
Mark
Précédent
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