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]