>
> [snip]
> >The newly recommended style is to create a one row table to
> > use for this purpose only and substitute it for RDB$DATABASE.
>
> Don't know about it being 'newly' recommended, I've always done this.
>
> create table dummy
> (
> id integer not null;
> );
> insert into dummy values(1);

Call id DUAL and you'll be Oracle compatible :)

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."