Hi all,

how to know at runtime the folder of a specific database ? ElevateDB Manager shows this in the datails window of a database.

Any hint ?

Regards,

Sergei Safar

the following code will do what you require.  (Well, it seems to works for me)

<Database> is the name of the Database.


  qyConfiguration.Close;
  qyConfiguration.DatabaseName := 'Configuration';
  qyConfiguration.SQL.Text := 'SELECT Path FROM Databases WHERE Name = ' +
QuotedStr(Database);
  qyConfiguration.Open;

  if (qyConfiguration.RecordCount = 0) then
  begin
     // ElevateDB Database not defined
  end;

Richard Harding

Hi Richard,

your code worked fine. Thank you.

Sergei Safar

"Sergei Safar" <hissa59 at ig com br> wrote in message
news:82DB5EA1-E0D5-4F98-958F-C1451C727D79@news.elevatesoft.com...
> Hi all,
>
> how to know at runtime the folder of a specific database ? ElevateDB
> Manager shows this in the datails window of a database.
>
> Any hint ?
>
> Regards,
>
> Sergei Safar

Or something like:

 CatalogTable.Open;
 if CatalogTable.Locate('Name', Database, []) then
   databasepath := CatalogTable.FieldByName('Path').AsString
 else
   databasepath := '?';
 CatalogTable.Close;

Roy