>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
Hi Tim.
Mark McCasland's builder is supposed to take care of this. What I did early on was create a method which did it all for me. It creates an empty cursor and using the field names in the empty cursor it builds the 3 main properties for me (UpdateNamelist, Updateablefieldlist and the Schema. This way I can instantiate a CA, progammatically put in the name of the table and Alias(1 CA handles 49 tables for me), do a GetData() which populates the properties and calls the cursurfill(). That way formats can change all they want.
Something to think about, though, when using Auto Incrementing fields. The Inserts CANNOT have those AutoInc fields included in the updatenamelist & updatablefieldlist properties. But when doing Deletes or Updates those fields MUST be included. I had to do a secondary population to handle this.
If you want my doc on it, or samples, let me know
- Glen -
The impossible we do immediately.
The miraculous will take a little longer.