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?
>
>I don't think so. If this is an issue, why not break the information into two or more views and cycle through them in the order you require.
Thanks Larry
That is probably the best way. I was trying to see if I could aviod that. My underlying data structure changed and normalizing forced the spliting up of several tables. If I use two views where I previously use one, I have to (find and) add an additional TABLEUPDATE for each view and have to change the ControlSource of about half the controls on my forms. Pain in the butt but probably no way around it.
Précédent
Suivant
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