>Hi,
>
>Is there a recommended way to rebuild a view in a database when fields have been added to the underlying table.

Are you talking about deploying the changes... or, are you just talking about in development? In both cases the Stonefield Database Toolkit will take care of this for you.

If you don't have that tool, what you will want to do is keep all of your views in code using one of the view generation tools around.

(You can use GenDBC which creates a program for the full database.)

Then, when you change the table, you can just edit your view prg and run it to update the view in the DBC.

BOb