Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Base table updates from a view
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Base table updates from a view
Divers
Thread ID:
00253460
Message ID:
00253460
Vues:
49
I have a remote view, created soley to reduce query time, that has 50 updateable fields scattered over five tables. I am hoping that one of you can tell me there is a better way to update the base tables than writing UPDATE yadada SET base_field_n = viewField_n where etc. for each of the base tables.

Were these local tables, the prefered option would be a regular set of relationships in the data environment.

As remote views the best option would be nested selects.
By nested selects I mean, from a QBF query on the parent, then on load data for child1, where key in qb_results, for bridge_table_key in QBF results, for bridge_table_child in bridge_table results, etc. This way, if selecting six records to work on, there would only be 6 bridge_table records loaded, not 1200+
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform