Has anyone used UltraGrid from Infragistics (
http://www.infragistics.com/) with FoxPro?
I want to build a several layer drill down and I think the Ultra Grid should be more flexible than the standard VFP grid.
The current product from Infragistiocs uses a newer version of Ultra Grid, but it is packaged with many controls and intended for Dot Net. FoxPro use as an active X is not supported. I called Infragistics and they were nice but would not provide any support if I am using Foxpro.
I cannot get the grid to display any data, much less a several layer drill down.
In a new project with just one remote view of SQL data everything seems to function correctly. The form data enviornment shows the remote view. I drop and size a new grid on my VFP form. I right click on the grid then go to SSUltraGrid Object then Retrive Structure or just Properties. I get the SSUltraGrid Properties form and then click on Groups & Columns Tab.
The Groups and Columns Tab provides a visual representation of the UltraGrid with abilities to Add/Remove/Show/Hide and arrange various elements of the UltraGrid hierarchy. However, no matter how I do it, the Add Groups Add Level Add Column buttons are always grayed out. The help pages says to just click on them and add a new group or level.
It seems there is not a way to attach data (in the case an ODBC remote view of SQL 2000 Table) to attach to the Ultragrid.
I guess my question really is:
Can UltraGrid work with FoxPro as an Active X control?