[SOLVED] Handling Field values having Apostrophe in Webfocus Variables
Hi I am drilling down from a field value which has an apostrophe ['] in it. [Banca Popolare dell’Emilia Romagna] this is the value being passed to a global Variable &&CON. For Example: -SET &&CON = '&ConGrp.EVAL' Dynamically what's being passed is: -SET &&CON = 'Banca Popolare dell’Emilia Romagna'
It the variable fails here and report execution breaks. Please input your suggestion, i need a help over this issue.This message has been edited. Last edited by: <Kathryn Henning>,
Webfocus 8105,8808,7703,7611, EXL2K,HTML,PDF,COMT,AHTML Info Assist+ , Reportcaster
October 20, 2014, 06:19 AM
Alan B
Try using:
-SET &&CON = &ConGrp.QUOTEDSTRING;
Alan. WF 7.705/8.007
October 21, 2014, 02:57 AM
iBeny
quote:
&ConGrp.QUOTEDSTRING
Whoaa!! It worked like a charm
Webfocus 8105,8808,7703,7611, EXL2K,HTML,PDF,COMT,AHTML Info Assist+ , Reportcaster
October 21, 2014, 07:04 AM
Wep5622
Don't use .EVAL if you don't need to evaluate the value of the parameter.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :