Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Geoff,
I don't know if it is an undocumented feature, but I do it often when verifying data that has been processed. I relate table1 and table2 on whatever common link fields, set filter to eof("table2"), set filter to not eof("table2"), set filter to table1.fieldx = somevalue etc. Normally only interactively when I am checking data in both tables in 2 browse windows to verify that related data was properly updated in both tables. I do not do this in runtime environment though because filters are very slow.
You can also create temporary indexes using fields from related tables in the index key. But you should not do this for a permanent index.
Elmer
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