March 31, 2006, 02:01 PM
rsWEBFOCUS ERROR
Hi
I am trying to use the &LINES command and it's returning 0 even though it's supposed to return 5 . Following is the piece of code I am trying to execute
---Begin
TABLE FILE ICMS_VW_CASE_UPDATED_AFTER_SARFILING
WHERE ( LASTTOUCHEDDATE GT MOSTRECENTFILEDDATE )
AND ( LAST_TOUCH_DATE GE BeginDate ) AND ( LAST_TOUCH_DATE LE EndDate );
ON TABLE HOLD AS HDICW00A
END
-RUN
-IF &LINES EQ 0 THEN GOTO EMPTY_RPT;
TABLE FILE HDICW00A
--End
I am also getting an error message at
thefollowing line
TABLE FILE HDICW00A
0 ERROR AT OR NEAR LINE 22 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC007) THE REQUEST STATEMENT DOES NOT CONTAIN A VERB
TABLE FILE HDICW00A
PRINT
Any help will be appreciated
March 31, 2006, 02:10 PM
PrarieYour first statement does not contain a verb like PRINT OR SUM. What happens after
TABLE FILE HDICW00A
Does it do anything?
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
April 07, 2006, 01:18 PM
KerryHi rs,
Has this issue been resolved on your site?
If not, I am wondering, can you please try the following code and let us know if it gives you any error message:
TABLE FILE HDICW00A
PRINT *
END
Here is the explanation of the FOC007 error message:
(FOC007) THE REQUEST STATEMENT DOES NOT CONTAIN A VERB
The request statement does not contain a verb, and the heading, if
any, does not contain a reference to any data fields, implying a
verb.
Hope this helps.
Cheers,
Kerry
Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
April 07, 2006, 01:33 PM
LeahWhat is the purpose of the -END right after the Table File statement?
Leah
April 08, 2006, 01:09 PM
rsThanks a lot Prairie & Kerry
As you mentioned this stmt did not have
a SUM or BY clause. hence the error
I introduced a SUM stmt and it fixed the error
rs