March 22, 2007, 10:32 AM
Jason K.syntax problems?
Hello!
I'm getting a (FOC261) EXPRESSION IS INCOMPLETE BECAUSE AN OPERATION IS MISSING
at line 57 in my code... Here's an excerpt:
TABLE FILE MATRIX_ORDERS_TBL
-GOTO ADD_DETAILS
-ADD_DETAILS
SUM
EXT_SALES_DOLLARS/P11BM AS 'Sales,This Yr.'
-IF &YEAR_COUNT GE '1' THEN GOTO P1SALES ELSE GOTO BGT_START
-P1SALES P1EXT_SALES_DOLLARS/P11BM AS 'Sales,Prior Yr.'
.....
this is line 57 from above...
EXT_SALES_DOLLARS/P11BM AS 'Sales,This Yr.'
I've tried it with a semicolon on line 58, it gives the same error.
I'm very new to coding with goto's, so I'm not sure where I'm going wrong.
Thanks!
March 22, 2007, 10:39 AM
Prariequote:
-P1SALES P1EXT_SALES_DOLLARS/P11BM AS 'Sales,Prior Yr.'
Why does this line have a dash in front
 | In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
March 22, 2007, 10:46 AM
Jason K.oh, that's my fault.
TABLE FILE MATRIX_ORDERS_TBL
-GOTO ADD_DETAILS
-ADD_DETAILS
SUM
EXT_SALES_DOLLARS/P11BM AS 'Sales,This Yr.'
-IF &YEAR_COUNT GE '1' THEN GOTO P1SALES ELSE GOTO BGT_START
-P1SALES
P1EXT_SALES_DOLLARS/P11BM AS 'Sales,Prior Yr.'
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
March 22, 2007, 10:49 AM
Jason K.I'm very sorry... it was a semicolon the entire time.
Thank you for your patience!
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.