Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bind a grid to recordset -ORACLE dynaset
Message
From
11/02/1999 11:31:22
 
 
To
11/02/1999 07:08:19
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00186423
Message ID:
00186569
Views:
15
>How come no one answers my posts?
>Well I'll try again.
>
>I amtrying to USe Oracle OLE Objects in Foxpro.
>The thing I can't do is bind the Dynaset (like a ado record set)
>to a grid.
>
>Anyone have experience with this?
>
>I tried to change the grid.recordsource to the dynaset name but it doesn't work.
>You can pick table or alias but it's not a table.
>
>Anyone ever bind a grid to a record set.
>If so how?

As of yet, VFP does not support ActiveX data binding. Your alternative is to try write a generic routine that will create a VFP cursor from your Oracle dataset by checking its field properties and iterating through its records. If communication will be 2-way (the grid will be updating the dataset) then you will need a routine that does the conversion the other way.

If you decide to use ADO, your work has been done for you, as there is at least one tool to do this DBF2RS/RS2DBF. I believet these routine are abvailable here in the files section, but if not, you can find them at www.classx.com.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform