Hello, Is there no option to use internal variables (composite) in a statement? Thank your.
------------------------- Hello, In a stored procedure there are 6 Input Parameters F1 to F6. This varchar variables contains table-field-names and I verify this. Now I thought I can use a statement like this: i = 0; while (i < 7) do begin idexists = 0; stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME = T_DT and RDB$FIELD_NAME = :' || 'F' || :i; execute statement :stmtxt into :idexists; if(idexists = 0) then begin --. break; end i = i + 1; end How can I use the content of F1 to F6 in this statement (not the name of variable rather the content). Actually the statement uses .._name = :F1 Thanks in advance. Best regards. Olaf [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
