Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Just wondering: Two views or one?
Good morning,
I have forms, w/a page frame, where:
- the first page displays a list of entries (in a non-updateable view); the user can select an entry and view/modify it on the second page
- the second page allows the user to add, delete or modify a single entry via an updateable paramatarized table buffered view
Right now, when changes are made on the second page, the view on the first page is REQUERYed (i'd previously looked into using the VIEW REFRESH() function, that "updates one or more records in a view with the current data from the original data source", but had trouble).
Now I'm thinking, why not use one updateable view for both pages?
Somehow, I felt more "sure" of what was happening, w/only one record in the the updateable view...but now, I'm thinking that it would be faster/simpler to use only a single view.
Any opinions to share? (opinions? on the UT?) TIA, J
Suivant
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