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]