Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Returning a parameter from a stored procedure
Message
 
 
À
09/03/2010 06:52:33
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01453371
Message ID:
01453409
Vues:
40
>My SQL stored procedure looks like:
>
>ALTER procedure [dbo].[Candidate_Insert_Blank] (@CreatedByID int, @Return1 int output, @Return2 int output)
>
>My native VFP code looks like:
>
>Return1 = 0
>Return2 = 0
>lnReturnCode = SQLExec(lnConnectionID, 'exec Candidate_Insert_Blank ?1, ?@Return1, ?@Return2', '')
>
>Therefore, I'm already passing by reference, am I not?

Yes, but the first parameter looks weird. Shouldn't be something like ?CreatedByID or 1?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform