General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only