General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only