Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who really uses the VFPOleDB.1 provider?
Message
From
05/10/2006 19:05:39
 
 
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158763
Message ID:
01159892
Views:
24
>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.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform