Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update order of views
Message
De
08/12/2000 12:02:32
 
 
À
08/12/2000 11:48:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00450829
Message ID:
00450836
Vues:
27
>If you have a updateable view based on two tables (or n tables), is there any way to tell/force the order in which the tables are updated?

What I've seen is that it has to do with the order the tables were joined in the cursor. So if you have table1 join table2, table1 updates first, then table2. If you change the select to table2 join table1, table2 should be updated first, then table1.

In the select statement of a view into VFP data, you can include the FORCE argument to the FROM clause to force the join in the order you have specified.
You would have to create the view in code and not the view designer in order to do this.
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform