I need to do thisd, once I've attempted to connect a database and found it to be absent. the Docs, and Helen's book make reference to using EXECUTE IMMEDIATE weith CREATE DATABASE, but not terribly explicitly.
It looks cumbersone because you're using EXECUTE IMMEDIATE to execute a prepared script. Wouldn't it make more sense to simply call isql and pass it the prepared database creation script anyway? Once the databse is created, then one can connect in the normal manner form within the application.
Regards,
Norman

----- Original Message -----
From: Norman McFarlane
To: firebird-support@yahoogroups.com
Sent: Monday, November 17, 2008 10:32 AM
Subject: Re: [firebird-support] SHOW DATABASES Equivalent


Thanks Martijn and Helen,
I thought as much. so I guess what one must attempt to connect to the database you expect to be there and trap the exception if it does not exist.
Regards,
Norman
----- Original Message -----
From: Martijn Tonies
To: firebird-support@yahoogroups.com
Sent: Monday, November 17, 2008 10:20 AM
Subject: Re: [firebird-support] SHOW DATABASES Equivalent

Hello Norman,

> I'm sure I've asked this before, but I can't for the life of me remember
the syntax.
> I need the firebird equivalent, if there is one, of the MySQL SHOW
DATABASES to return a result set which is a list of databases.

There isn't one.

Firebird doesn't keep track of it's databases, a database is a
datafile that can be used, that's all.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Sybase
SQL Anywhere, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

----------------------------------------------------------

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1793 - Release Date: 11/16/2008 7:58 PM

[Non-text portions of this message have been removed]






------------------------------------------------------------------------------



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1793 - Release Date: 11/16/2008 7:58 PM


[Non-text portions of this message have been removed]