>>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)