Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A moved view still looks at data in original directory
Message
De
31/10/1999 14:05:37
 
 
À
31/10/1999 13:04:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00284536
Message ID:
00284548
Vues:
18
>Hi,
>
>We have written an application which allows the user to make a backup copy of their data directory. They can do this as many times as they wish, and can use one or more of these backups for training [the application allows the user to specify which directory contains her data].
>
>The dbc and dbf files etc. are simply copied to the new directory.
>
>This all works fine, except that two views are included in the dbc. We have found that these views still get data from the directory they were originally copied instead of the new directory which the dbc has been copied into.
>
>I'm assuming that the view stores a path to the table[s] it is based on when it is originally created. If we remove the original directory, everything works fine, so the view must look for the original and, if it doesn't find it, look along the path for the tables it is based on.
>
>How do we get around this ?
>
>Best.
>
>Matt.

A view doesn't store paths, it only stores database names. The tables that a view uses when it is opened depend on the current database, and the current path.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform