Subject Re: [ib-support] MONTH
Author Martijn Tonies
> [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

Upscene Productions

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