Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Who really uses the VFPOleDB.1 provider?
Message
De
05/10/2006 19:05:39
 
 
À
05/10/2006 04:19:33
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01158763
Message ID:
01159892
Vues:
25
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform