This CursorAdapter ClassLib builder will create a VCX of CAs for every table in a DBC, SQL Server database or Oracle schema. The CA baseclass and subclasses in the ClassLib should handle just about every option a CA would be used with respect to Native, ADO, ODBC, SQL Server and Oracle. I even threw in a _CA_ReadMe method in the CA baseclass in the VCX that documents some gotchas and how to use the ClassLib. There is also an extensive set of comments at the beginning of the builder on how to use the builder.
I have been testing it against the Northwind database in SQL Server and the DBC version using ADO, ODBC and Native. I have also tested against an Oracle database using ADO and ODBC. All you have to do is set a few custom properties at the baseclass level, then some custom properties when you add a CA subclass to a DE. I can’t think of how to make it much simpler than that.
Please let me know if the resulting ClassLib is as complete and functional as I think it is.
Please see Download #
17264 in the UT Downloads
Mark McCasland
Midlothian, TX USA