Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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.
Thanks Trey,
That has been my experience also but I was wondering if someone knew this for a fact. My fear is that my assumption will come back to haunt me later. I think I'll have to go with Larry's suggestion unless I can get some more confirmation on this.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement