Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to access VFP tables from VB using VFPCOM
Message
De
19/10/1999 08:47:28
 
 
À
19/10/1999 08:34:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00278023
Message ID:
00278102
Vues:
18
For a record at a time, this is a good alternative and the one I would suggest. But if you want to display multiples records in a grid, an ADO recordset is a much better way of passing informations, IMHO. Having to call MoveNext on each record would take time since there is a performance penalty to take when pasing informations between tiers. It much less costlier to pass an object (ADO) than a series of records via MoveNext.
>I've never done this, so this might be just another wild idea, but here goes anyway. How about simply dumping ADO altogether and having your VFP COM object do the work? Methods like VFPObject.Fields("Somefield") can easily be made, or MoveNext, MoveFirst, etc.
>
>I've never used ADO other than in VB, but I just can't figure out what are the advantages of using ADO compared to what VFP offers.
>
>As for updating the data (without ADO), updatable views should work I beleive, or you could build your UPDATE SQL statement using GETFLDSTATE().
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform