Im about to switch an application from Access to firebird.

The following simple select statement performed flawlessly with Access


select LocationId, LocationName from Locations
union
select -5, '(new location)' from Locations
order by 2;

Firebird, however, reports an SQL Error

Dynamic SQL Error
SQL error code = -104
Invalid command
Data type unknown

LocationId is an Integer, LocationName a Varchar(64). What's wrong with it?

Thanks

Rolf Nussbaumer