Hi Andy,

Sorry, but it still doesn't work. First, it pops up View parameter dialog. If I enter anything, ODBC error is generated "[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure proc_test has no parameters and arguments were supplied". Here's SQL Server stored procedure and VFP code I'm using.

CREATE PROCEDURE proc_test 
AS
	SELECT getdate()
RETURN 123
* VFP code...
PRIVATE puRetval
lnResult = SQLEXEC(lnConn ,[EXEC Proc_test ?@puRetval] )

>Hi Sergey
>
>>Your code fails during compilation on the second line with message "Missing operand" (VFP8SP1).
>
>Whoops, thank you - the closing bracket is in the wrong place. Try this...
>
>>>

>>>PRIVATE puRetVal
>>>SQLEXEC( nCon, [EXEC sp_name ?@puRetVal] )
>>>

>
>(It was cut down from some more complex production code and I got it wrong - sorry).