Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning a parameter from a stored procedure
Message
 
 
To
09/03/2010 06:52:33
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01453371
Message ID:
01453409
Views:
39
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform