Hi Andy,

I'm aware about output parameters but original question was how in VFP retrieve return value of a stored procedure ( the one in RETURN 123) not how to return value from the stored procedure. I thougth that you new some trick to do that with output parameter but it turned out that you where answering wrong question.

>Hi Sergey
>
>>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".
>
>My fault - I assumed you knew about this one - I wasn't being very clear - sorry.
>
>You actually have two things going on here.
>
>[1] You must declare the parameter as OUTPUT in the Stored Procedure.
>[2] Second you must initialize the privvate variable because unlike a LOCAL or PUBLIC declaration, VFP doesn't actually create the variable when you merely use PRIVATE. Try the following:
>
< snip >