select LocationId, LocationName from Locations
union
select CASE(-5 AS INTEGER), CAST('(new location)' AS VARCHAR(64)) from Locations
order by 2;



Rolf & Sibylle Nussbaumer wrote:

>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
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus