General information
Category:
Object Oriented Programming
Jim,
I haven't used any of this, but what I have run across is the following:
A series of ADO articles in FoxPro Advsior, Spring and Summer, 2000.
VfpCom.ComUtil which has CursorToRS and RSToCursor methods.
ADO recordsets can be bound to any VFP form control but a grid. Use the MS FlexGrid for grid functionality bound to an ADO recordset.
Maybe John Petersen will drop by here with some advice or answers to specific questions.
>I am using VFP 6 as a front-end to a SQL Server 7 database in a new application, and I have been working with ADO objects for the data access mechanism. After exploring views and SQL Pass-through, these seem to be a bit easier to use for me.
>
> I have created a set of my own data objects as wrappers for the ADO recordsets, and this allows me to do things like validation and business rules before actually changing table data. I haven't thought of a good way to deal with parent-child relationships in the user interface yet, however. I would like to be able to get an ADO recordset (as a child in a relation) into a grid, for example, bound to a parent key, much as SET RELATION works in regular VFP tables. As an alternative, there is a way to load ADO data into an array, which could be used to fill a list box or something. I was just wondering if I am missing anything obvious here. Like any way to bind a grid to something other than a cursor.
>
>Any help would be greatly appreciated, or even a good single-source for ADO object documentation. I got a good head start with an MSDN article called 'ADO jumpstart for VFP developers'
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only