>>General Structure should be:
>>

>>*VFP Stored Procedure:
>>PROCEDURE DoSomething
>>  LPARAMETERS x
>>  SELECT * FROM myTable WHERE something = x INTO CURSOR myCursor
>>  RETURN SETRESULTSET("myCursor")
>>ENDPROC
>>

and in VB.NET something like:

>>...
>>With oCommand
>>  .CommandType = CommandType.StoredProcedure
>>  .CommandText = "DoSomething"
>>  '.Parameters.Add .....
>>End With
>>da.SelectCommand = oCommand
>>da.Fill(oDataSet)

>>
>>Can't remember for sure whether it's a issue but JIC best use NOFILTER on the cursor to be returned...
>
>The NOFILTER is not a factor. This has no impact better or worst on the situation.

I wasn't thinking of NOFILTER in terms of either performance or error reduction. I just seem to remember that if the query only produced a filtered result the cursor couldn't be passed back from the proc (but I might be wrong)