Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to access VFP tables from VB using VFPCOM
Message
From
19/10/1999 08:47:28
 
 
To
19/10/1999 08:34:50
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00278023
Message ID:
00278102
Views:
17
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().
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform