Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling a SQL stored procedure with parameters
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00612744
Message ID:
00612758
Views:
23
Juan,
Try:
iexist = 0
lcsqlExec="EXEC Test 'A9999', ?@iexist"
nerror=SQLExec(nh,lcSql)
Output parameters are passed by reference and must therefore be declared before calling the sproc.

HTH
>I have a Microsoft SQL Stored Procedure with the following declaration
>Create Procedure Test
> @cps_1 [char](5),
> @iexist int OUTPUT)
>...
>...
>
>From Visulafoxpro after the connection I have the following instruction:
>lcsqlExec="Execute Test 'A9999",?@iexist OUTPUT'
>
>nerror=SQLExec(nh,lcSql)
>
>This instruccion returns the following error:
>
>Incorrect Syntaxis near 'OUTPUT'
>
>What's wrong or how I must declare the output parameter?
>Thanks
Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform