Jon,

Unfortunately, VFP sproc's don't support returning of result set, only scalar value.

>For some weird reason I cannot figure out how to properly code a stored proc to return a result set when executed through the OLE DB provider.
>
>Shouldn't SELECT * FROM TableName in the stored proc return a record set that gets processed by the provider as a query result? Whenever I try this, all I get back is a return value of 1 and not the data that the stored proc is attempting to return.
>
>What silly thing am I forgetting?
>
>Laterness,
>Jon