Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Just wondering: Two views or one?
Message
From
01/02/2001 16:12:40
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Just wondering: Two views or one?
Miscellaneous
Thread ID:
00471454
Message ID:
00471454
Views:
39
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
Map
View

Click here to load this message in the networking platform