[SOLVED]Error In HTML running, Double quotes needs to be resolved
Hello, I am having some double quotes while running an HTML on Web focus 8.This is the error I found.
WHERE ( PVTFT001_COV_MO_FT.T7_PVTDM051_CURR_ORG.PROD_NA EQ '''CHUBB INSURANCE SOLUTIONS AGENCY INC (CAP/BOS)''' ); WHERE ( PVTFT001_COV_MO_FT.T8_PVTDM061_LOC_DM.ST_PROV_AB EQ 'CA' ); WHERE ( PVTFT001_COV_MO_FT.T7_PVTDM051_CURR_ORG.PROD_BR_NA EQ '''BOSTON''' ); WHERE PVTFT001_COV_MO_FT.T7_PVTDM051_CURR_ORG.CPI_TRR_NA EQ '''EAST US TERRTY'''; WHERE PVTFT001_COV_MO_FT.T3_PVTDM011MO_YR_DM.ISO_CAL_Y_MO_AB EQ '2015-07'; WHERE PVTFT001_COV_MO_FT.T6_PVTDM041_COV_DM.CV_DSPLY_NA EQ 'Assisted Living Care';
My source code of Fex is
WHERE ( PVTFT001_COV_MO_FT.T7_PVTDM051_CURR_ORG.PROD_NA EQ &PROD_NA.QUOTEDSTRING ); WHERE ( PVTFT001_COV_MO_FT.T8_PVTDM061_LOC_DM.ST_PROV_AB EQ &ST_PROV_AB.QUOTEDSTRING ); WHERE ( PVTFT001_COV_MO_FT.T7_PVTDM051_CURR_ORG.PROD_BR_NA EQ &PROD_BR_NA.QUOTEDSTRING ); WHERE PVTFT001_COV_MO_FT.T7_PVTDM051_CURR_ORG.CPI_TRR_NA EQ &CPI_TRR_NA.QUOTEDSTRING; WHERE PVTFT001_COV_MO_FT.T3_PVTDM011MO_YR_DM.ISO_CAL_Y_MO_AB EQ &ISO_CAL_Y_MO_AB.QUOTEDSTRING; WHERE PVTFT001_COV_MO_FT.T6_PVTDM041_COV_DM.CV_DSPLY_NA EQ &CV_DSPLY_NA.QUOTEDSTRING;
I am new to Development. Please help NihaThis message has been edited. Last edited by: <Emily McAllister>,
WebFOCUS 8 Windows 7 HTML
December 13, 2015, 04:07 PM
Waz
Looks like your & variable already has quotes
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
December 14, 2015, 09:18 AM
N/A
Hai, Waz Thanks for answering. Since I am new to Development, I am unable to debug. What is your suggestion and how to fix it? Regards, Niha
WebFOCUS 8 Windows 7 HTML
December 14, 2015, 09:25 AM
Wep5622
Two options:
Don't quote your strings, which you possibly did via an option in your HTML launch page, or
Don't use .QUOTEDSTRING
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 :
December 14, 2015, 04:08 PM
Waz
Another option is to check your amper variables before the TABLE request, and remove the QUOTEDSTRING.
e.g.
-SET &PROD_NA = IF &PROD_NA CONTAINS '''' THEN &PROD_NA ELSE '''' || &PROD_NA || '''' ;
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
December 17, 2015, 09:59 AM
N/A
Hai, Thans. I removed quotedstring and it worked.Thanks Niha