Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Too many Joins???
Message
From
19/04/2000 15:19:08
 
 
To
19/04/2000 14:21:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00329636
Message ID:
00361508
Views:
19
Yes, BUT you should make certain that the updateable table(s) are the last added. You must also ensure that each view is flagged as updateable(appropriate fields) with send sql updates = T. It is a very good idea to use on update triggers to ensure data integratity or cascading changes. The lowest level tables, (the first views in the hierachy) should be ones that very seldom change the core data. I.E. a table, STATE, will likely only have 50 records for a very long time, but a record above it may change state frequently, simply by changing the foriegn key to STATE.
A lot depends on the usage you will need for the data. The sub-views should be static while the parent view is active.
Previous
Reply
Map
View

Click here to load this message in the networking platform