Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapters Updating fields
Message
From
28/02/2003 14:11:38
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00758891
Message ID:
00759565
Views:
18
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform