Hello Helen,
>... >declare variable fname varchar(31); >... >i = 1; >while (i< 7) do >begin >fname = 'F' || cast (i as char); >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 = ' || fname; >execute statement stmtxt into :idexists; >if(idexists = 0) then >begin >--. >break; >end >i = i + 1; >end >./hb Thank you, but I can see only the name of the variable in my stmtxt (.name = F1). It should be the value of the variable.) At the moment I have realized it with an separate stored procedure (check the value) and returning okay or not. But I must call it 6 Times. If there is another solution, please help. Thank you all. [Non-text portions of this message have been removed]
