I simply cannot chase down the error in this &ECHO. Can anyone lend an eye ?
quote:
ERROR AT OR NEAR LINE 16 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC262) UNBALANCED PARENTHESES (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COMMAND
-DEFAULT &DATE1 = '20180301';
TABLE FILE WF_RETAIL
SUM
WF_RETAIL.WF_RETAIL_SALES.COGS_US
WF_RETAIL.WF_RETAIL_SALES.QUANTITY_SOLD
WF_RETAIL.WF_RETAIL_SALES.REVENUE_US
BY LOWEST WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
BY LOWEST WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
BY LOWEST WF_RETAIL.WF_RETAIL_PRODUCT.MODEL
BY LOWEST WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT
IF RECORDLIMIT EQ 25
WHERE ( WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ 'Accessories' );
WHERE ( WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT EQ 20180301.(|FORMAT=YYMD).Sale,Date:.QUOTEDSTRING );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE _EDAHOME/ETC/warm.sty
$ Copyright 1996-2015 Information Builders, Inc. All rights reserved.
-* $Revision: 1.32 $
*TABLE_STYLE
TYPE=REPORT,
GRID=OFF,
FONT='IBIDefault',
SIZE=9,
STYLE=NORMAL,
SQUEEZE=ON,
COLOR=RGB(20 20 20),
PAGECOLOR='WHITE',
BORDER-COLOR=RGB(219 219 219),
TITLELINE=SKIP,
HYPERLINK-COLOR=RGB(51 102 255),
$
TYPE=REPORT,GRAPHCOLOR='SILVER',GRAPHCOLORNEG='RED',GRAPHWIDTH=.18,$
TYPE=REPORT,
OBJECT=MENU,
SIZE=9,
. . . . . . . .
This message has been edited. Last edited by: FP Mod Chuck,