Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement