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
Title:
Calling a SQL stored procedure with parameters
Miscellaneous
Thread ID:
00612744
Message ID:
00612744
Views:
55
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
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E
Next
Reply
Map
View

Click here to load this message in the networking platform