|Subject||RE: [firebird-support] String with added string-variable|
|Author||Svein Erling Tysvær|
>I use a String and would like to add a string-variable to the string. I need before and after the string the little 'Four isn't enough, add more! At least I wrote a simple stored procedure and
>..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.
MyStatement = 'SELECT ''''''Olaf Kluge'''''' FROM RDB$DATABASE';
EXECUTE STATEMENT MyStatement INTO OUTPARAM;
Returned the desired