Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VFP and ADO

Status
Not open for further replies.

VFP7

Programmer
Jan 17, 2001
15
IN
Hello friends

Thanks for the great help I got from this forum.

This time I have a tricky one. I am involved in writing an off-the-shelf application framework for VFP. Which is also for my own use in the time to come. Lots of the work is done. I was just browsing my old archives of this forum's ariticles and questions when I clicked with ADO.

In my framework I have made provisions to let a form switch (by a property setting) to use either ODBC aware RecordManager or native VFP Recordmanager. here I would like to clerify that RecordManager is a custom class that handles all record related activities of a form. Based on the datasource type form can be designed to use either of the two record managers both of them have idetical methods but the way of working, is ofcourse different.

Well regarding ADO, I know that its RecordSet object is based on VFP Cusror engine. I know the basics of the entire ADO framework. But I am wondering, if anything like SET RELATION TO or INDEX ON FIELD1 + FIELD2 TAG TAG1, etc exist in ADO ?

Last but not the least would any expert overhere tell me that...

A) Am I right, if I am planning to make two identical classes, one uses Native record managing comands and other ADO commands. Would it be a right approach to delve into ?

B) Can I use ADO only for native data access too. I know I can, but would be be more fast or equally fast as it is with native VFP commands ?

Thanks a lot in advance.

Vikas Burman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top