>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 am running more tests tonight. I will let you know later on about the result when being run in such approach.