Thanks Vlad. But, I'm not using SQL Server, but VFP database instead.
>Hi!
>
>It is depended on what you're gouing to return from SQL Server. When this is SQl Server 2000 and you use a function-like SP, no need to use separate table:
>
>

>SQLEXEC(nHandle,'SELECT SP_TEST() AS result')
>

>
>"FROM" is not required on SQL Server. You can return this way values of system variables on SQL Server.
>
>When you want to return a recordset from the usual SP, when this result set is created by a query inside of SP:
>

>SQLEXEC(nHandle,'exec SP_TEST','SPResult')
>

>
>When you want to return a return code from the usual stored procedure, put it into the variable and then return it:
>

>DEFINE CRLF chr(13)+chr(10)
>SQLEXEC(nHandle,'declare @nCode int' + CRLF+ ;
>                'exec @nCode=SP_TEST'+CRLF+;
>                'select @nCode as result','SPResult')
>

>HTH.
>
>
>>I am developing an n-tier application. For now, I'd like to have my VFP middle tier use ODBC to connect to a VFP datasource. The back-end data will have several stored procedures that my middle tier will need to call.
>>
>>How do I call a stored procedure in a VFP database via SQL Pass thru. As a work-around, I put a one-row-table, called SP, in the vfp database and use SQLEXEC to send a query to the DB with the stored procedure as a column. Like this:
>>
>>SQLEXEC(nHandle,'SELECT SP_TEST() AS result FROM SP','SPResult')
>>
>>Although this works, it seems kind of silly. There must be a better way.