>After upgrading from VFP6 to VFP9 I have discovered that the vfpcom.dll does not work with the VFP9 runtime files. I use the vfpcom.comutil class to convert vfp cursors to ADO recordsets for use with web pages. I need this functionality. Can this be accomplished with the CursorAdapter class? If not, what other options are there?
The VFP team is working on enhancing VFPCOM.DLL for VFP 9.0, and I will post a blog entry when it is updated online. The VFP team recommends you consider using CursorAdapter to do this:
1. The Recordset must be created manually
2. The recordset should be attached to a CursorAdapter by passing it as a 4th parameter to CursorFill method (DataSourceType should be "ADO").
3. Set UpdatableFieldList
4. Insert records into cursor and call TABLEUPDATE().