>Is there an easier way to use the updatenamelist and the updatablefieldlist properties for the CursorAdapter. I want all of my fields to be updatable but I do not want to type in each field name in the these properties. Is there a better way? Like some kind of wild card "*" of some sort?
>
>Thanks
>Tim Boccaleri
Start with my CursorAdapter VCX Builder and examples. Download them from:
http://www.mctweedle.com/downloads/CABuilder.ziphttp://www.mctweedle.com/downloads/CursorAdapter.zipThe builder will create VCX with a CA baseclass. Then CA subclass will be created based on the CA baseclass for every table in a DBC, SQL Server database or Oracle schema. Just read the comments and demo code at the beginning of the PRG file. In each CA subclass will be the code that populates all the field list properties for you. All you have to do is tweek what you do not want to update or how you want something updated, inserted or deleted.
The CursorAdapter zip file contains sample PRG files for using CAs with different backends and data source types [Native, ADO, ODBC].
Mark McCasland
Midlothian, TX USA