> in interbase scripts we widely use following construction
>
> set echo off;
> set list on;
> output tmp.sql;
> select sqlStatement || "" from storedProcedure;
> /* e.g. select rdb$relation_id || '' from rdb$database */
> ...
> output;
> input tmp.sql;
>
> to dynamically generate and execute dynamic scripts. '|| ""' part was
> needed in interbase (5.6, 6.0.2) to get rid of column name in front
> of resulting sql statement. This behavior is different in firebird
> (v1.5rc7) - it puts auto generated column name 'CONCATENATION' in
> front of resulting sql statement causing dynamic script to fail. Any
> ideas how to make those column names disappear, or other ways how to
> create dynamic scripts that would work in both firebird and interbase?

Yes, it seems there has been something changed in FB 1.5.
FB 1.0 works like IB 5.6, IB 6.0.2 in that issue.

Though, in a dialect 3 database you can do something like
that:

select rdb$character_set_name || '' as "" from rdb$database;

In a dialect 1 database (and I'm pretty sure that you are using a
dialect 1 database), I don't know, because there aren't delimited
identifiers available.

Perhaps someone else has an idea. ;-)



Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server 7
http://www.adslogmanager.com