Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I was thinking of creating a view based on the whole table, the view would have some calculated fields in it, then I would create small views based off the first view to directly populate a grid.
>
>I am not sure that the second view would update the original table. I may be better off just creating lots of small views for each grid required.
You may have to provide more info on this, it's a bit vague to me at the moment.
>I have another question, we have just ordered VFP7 (we are currently using VFP6) and was wondering what advantaged a view has over a updateable SQL statement?
Unfortunately I can't answer that, we are still using VFP6.
Kev
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