>>Take a look at StoneField Database Toolkit... it has a feature that allows you to ship a new .DBC and meta data and then you call the UPDATE() function and the tables will be updated as needed.
>
>Bob,
>
>Thanks for the info, I will take a look. How difficult is it to integrate Stonefield DB toolkit to an existing app?
>
>Mat

It is actually very easy... just add two class libraries to your project... and create the meta data with the Database Explorer. Use the DataBase explorer to modify your database... then, doing what you ask is as easy as shipping a new .DBC and Metadata files (4 .dbfs) and calling oMeta.oSDT.Update().

Of course, as you see what it can do, you may/will want to use more features of the data dictionary in your application!

BOb