truewodzu wrote:

> I just don't get why this SELECT statements doesn't work as they work on the MS SQL Server. I know, two different engines. But what am I doing wrong?
>
> FIRST EXAMPLE:
>
> SELECT 5
>
> I would expect to get a result with one row and one column and the value 5, instead of I am getting this error in FlameRobin:

http://www.firebirdfaq.org/faq30

> SELECT *, (1+1) AS test FROM CITIES
>
> Again, I would expect to have in each row a column called "test" with the value of 2 in it. Instead:

Try:

select cities.*, (1+1) as test from cities

> EXECUTE BLOCK

EXECUTE BLOCK RETURNING...

Regards,

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================