Hi Team,
I have an EDB Store called 'Exports' in E:\DBiWorkflow\Data\Exports.
This is fine for me but not relevant to my Client.
Is there a way to retrieve the EDB Store 'Exports' drive/directory from within Delphi?

Regards & TIA,
Ian

Ian


select Name, Path from configuration.stores

Roy Lambert

Done & Dusted.
Thanks Roy.

Ian


These days when I want to find out anything about the system / database I look to see if there's a configuration or information table - worth having a look at the schema in EDBManager's OLH

Roy Lambert

Hi Roy,
Ahhh.  I looked up Configuration Database and it listed what I guess are all the tables in the configuration database.
I never realised, nor did it occur to me that it was there.
Another lesson learned, another day not wasted.

Regards,
Ian

Ian,

<< I have an EDB Store called 'Exports' in E:\DBiWorkflow\Data\Exports.
This is fine for me but not relevant to my Client. >>

In addition to your original question, you can use relative path names to make this easier to deal with.  In such a case, you can set your configuration file path to 'E:\DBiWorkflow', set your Database path to 'Data', and finally set your store to 'Data\Exports', and EDB will resolve these all without issue as long as the Data and Exports paths are always present underneath the configuration file directory.

This feature allows you to move configuration files around without worrying about updating the paths for all of the included database and store objects.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
>>In addition to your original question, you can use relative path names to make this easier to deal with.  In such a case, you can set your configuration file path to 'E:\DBiWorkflow', set your Database path to 'Data', and finally set your store to 'Data\Exports', and EDB will resolve these all without issue as long as the Data and Exports paths are always present underneath the configuration file directory.

>>This feature allows you to move configuration files around without worrying about updating the paths for all of the included database and store objects.


Ahh.  Now that's handy.  Thanks Tim