>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