Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Doug.
>
>>Does anybody have some example code to USE a .DBC (ie not OPEN DATABASE) and read from its Property field the table name and path for all contained tables (objecttype = Table)?
>
>You don't need to open the DBC as a table. Just get a array of tables in the DBC using ADBOBJECTS(), then spin through that array and use DBGETPROP() to get the Path property of each table. Don't forget to FULLPATH() this property against DBC() before using FILE() to see if it exists, because the path is stored relative to the location of the DBC.
Many thanks for the suggestion. However, the DBC needs to be open to use ADOBJECTS(), and the solution I am looking for needs to be implemented before that database is open.
Kevin
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