Hi there,


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 child 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?


Thanks,

Paulius