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
Niha

This message has been edited. Last edited by: <Emily McAllister>,

Looks like your & variable already has quotes

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

Two options:

• Don't quote your strings, which you possibly did via an option in your HTML launch page, or
• Don't use .QUOTEDSTRING

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 || '''' ;

Hai,
Thans. I removed quotedstring and it worked.Thanks
Niha