Hi,

> It's possible in FB 1.5 to do somethig like this?...
>
> SELECT 1 as ONE
>
> (IN MySQL, MsSQL this code returns 1 in a column named ONE)...
>
> But, in FB this raises an error because, the FROM clause is required for
> SELECTs... So, How can I produce the similar effect in FB?...

SELECT
1 AS ONE
FROM
RDB$DATABASE


RDB$DATABASE is a system-table that always contains one record.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81


See you at the First European Firebird Conference May 19-20 in Fulda,
Germany
http://www.firebird-conference.com