Richard Wesley wrote:

> Interestingly enough, I was trying to come up with a method that
> would work for all the database engines we support. They all have a
> variant of FIRST:
>
> Firebird: select first 1 ...
> MySQL: select ... limit 1
> MS Jet, MS SQL Server: select top 1...
> Oracle: select * from (select ...) where rownum <= 1;
>
> None of them have Rdb$database however ;-)
> ________________________________________________________
> Richard Wesley Software Engineer
> Tableau Software
> (w) +1-206-633-3400x505
> hawkfish@...
> http://www.tableausoftware.com/
>

Richard,

Oracle has DUAL

MSSQL and MySQL I don't know, but wht won't you create your own table
with just onde record and use it everywhere ?

create table TableuDual as (a integer);
commit;
insert into TableDual values (1);
commit;

be happy :-)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br