Re: AW: [firebird-support] statement and composite variable names

2012-05-30 Thread Milan Babuskov
Olaf Kluge wrote: How can I realize: Fiels_name = 'COLUMNNAME''? Fiels_name = ''COLUMNNAME' I have test all combinations from one ' to four. How about five ' ? ;) -- Milan Babuskov == The easiest way to import XML, CSV and textual files into

AW: [firebird-support] statement and composite variable names

2012-05-23 Thread Olaf Kluge
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

Re: AW: [firebird-support] statement and composite variable names

2012-05-23 Thread Thomas Steinmaurer
Olaf, Is there no option to use internal variables (composite) in a statement? IMHO, it isn't entirely clear what you want to achieve. Regards, Thomas Thank your. - Hello, In a stored procedure there are 6 Input Parameters F1 to F6. This varchar variables

AW: [firebird-support] statement and composite variable names

2012-05-23 Thread Olaf Kluge
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