Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Error: FOC262 UNBALANCED PARENTHESES
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Error: FOC262 UNBALANCED PARENTHESES
 Login/Join
 
Master
posted
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,


Tomsweb
WebFOCUS 8.1.05M, 8.2.01
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 522 | Location: Baltimore, MD | Registered: July 06, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Add ) at the end...
  
WHERE ( WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT EQ 20180301.(|FORMAT=YYMD).Sale,Date:.QUOTEDSTRING ));


Tom Flynn
WebFOCUS 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1934 | Location: Parker, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Quote:
WHERE ( WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT EQ 20180301.(|FORMAT=YYMD).Sale,Date:.QUOTEDSTRING );


Please post the raw code for this line. &ECHO=ON should show a resolved value in place of each referenced &var, so
.(|FORMAT=YYMD).Sale,Date:.QUOTEDSTRING"
should have been swallowed along with the name of the &var.


- Jack Gross
WF through 8.1.05
 
Posts: 1924 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Error: FOC262 UNBALANCED PARENTHESES

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.