>*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)Yes, there wouldn't be any problem with that. But, I just can't use files on disk. I have over 2000 SQLs and many of them are generated when required by adding INNER JOINs, based on condition statements, for example. So, I need to do it from code directly in VB.NET. It would't make any sense also to create files on disk several times per second, which would be here in the range of 40 files per second.