| Subject | R: [firebird-support] String with added string-variable | 
|---|---|
| Author | Olaf Kluge | 
| Post date | 2012-05-24T16:01:08Z | 
Hello,
 
I have test it now.
 
stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM
RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = T_DT
and RDB$FIELD_NAME = ''''' || fname || '''''';
 
execute statement stmtxt into :idexists;
 
The stmtxt is '..._Name = '''COLUMNAME'''' and I get an SQL-Error. The
statement-text should be '..._Name = 'COLUMNNAME''.
 
I will test a little bit tomorrow.
 
Thanks for helping.
 
 
Regards.
 
Olaf
 
[Non-text portions of this message have been removed]
            I have test it now.
stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM
RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = T_DT
and RDB$FIELD_NAME = ''''' || fname || '''''';
execute statement stmtxt into :idexists;
The stmtxt is '..._Name = '''COLUMNAME'''' and I get an SQL-Error. The
statement-text should be '..._Name = 'COLUMNNAME''.
I will test a little bit tomorrow.
Thanks for helping.
Regards.
Olaf
[Non-text portions of this message have been removed]