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