Hi Guys,
Could someone please tell me what is the best way to check for an existing database?
When I use
     MainFrm.FDASession1.Execute('CREATE DATABASE "FDADb" PATH ' +
                                 Quote('c:\fda\data') +
                                ' DESCRIPTION ''FDA Database''');
it sometimes already exists, and I get the warning message.
Is there something similar to checking for tables by using
     if (Execute('Select * From Information.Tables '+ 'Where Name='+Engine.QuotedSQLStr('Prefs'))=1) then...
but for the database instead, or should some code be placed in the "before connect" of the database?
Thanks
Colin

You can query the configuration database. something like :

SELECT * from Configuration.Databases where Name='<your db name>'

If this returns data then db exists

Raul

On 9/8/2012 9:51 PM, Colin Wood wrote:
> Hi Guys,
> Could someone please tell me what is the best way to check for an existing database?

Colin


And if you follow up Raul's suggestion with a FileExists tests for the catalog file it will tell you if the database really exists on the harddrive. Only needed if you're paranoid or someone messes with your system


Roy Lambert [Team Elevate]

Thanks Raul and Roy.  Paranoia comes naturally!