>I use a String and would like to add a string-variable to the string. I need >before and after the string the little ' > >..and RDB$FIELD_NAME = ''' || fname || ''''; > >results: field_name = ''COLUMNNAME''' and returns a sql exception. > >and RDB$FIELD_NAME = ''' || fname || '''; goes wrong. All the text after is >marked as text. > >How can I realize: > >Fiels_name = 'COLUMNNAME''? I have test all combinations from one ' to four.
Four isn't enough, add more! At least I wrote a simple stored procedure and MyStatement = 'SELECT ''''''Olaf Kluge'''''' FROM RDB$DATABASE'; EXECUTE STATEMENT MyStatement INTO OUTPARAM; SUSPEND; Returned the desired 'Olaf Kluge' HTH, Set
