You can only return a single value from a stored procedure in VFP8 and earlier.
In VFP9 SETRESULTSET() function can be used to return a cursor.
>How can I determine the view returned from a stored procedure?
>
>The scenario is this:
>
>I need to connect from an ASP.NET page to a VFP DBC, but it is not
>enough with a simple SQL query. So I am making a stored procedure which
>creates the data I need. However, it creates several views, only one of which
>I want to return to the ASP.NET page.
>
>How do I tell VFP which one to return?
>
>
>Peter
--sb--