I am facing the below error message can you plaese suggest what is the problem.

(FOC006) THE FORMAT OF THE TEST VALUE IS INCONSISTENT WITH FIELD FORMAT:
BYPASSING TO END OF COMMAND

(FOC009) INCOMPLETE REQUEST STATEMENT



-SET &CA_AMT=' 0';
-SET &CS_AMT=' 0';
-SET &CC_AMT=' 0';
TABLE FILE RSPOPSM
SUM
CA_AMOUNT
CS_AMOUNT
CC_AMOUNT

WHERE BAN EQ &BAN
AND CYCLE_CODE GE &FROMCYCLE AND CYCLE_CODE LE &TOCYCLE
AND MONTH GE &FROMMONTH AND MONTH LE &TOMONTH
AND YEAR GE &FROMYEAR AND YEAR LE &TOYEAR

ON TABLE SAVE AS DDPOPSUM
END
-RUN
-IF &LINES EQ 0 THEN GOTO DEF_POP_AMT;
-READ DDPOPSUM &CA_AMT.A12, &CS_AMT.A12, &CC_AMT.A12.
-DEF_POP_AMT
-SET &TOT_C_AMT=&CA_AMT+&CS_AMT+&CC_AMT;
TABLE FILE RSRCSM
HEADING
-INCLUDE gnrphdr.fex
" "
"<46 From Cycle : &FROMCYCLE-&FROMMONTH/&FROMYEAR
<71 To Cycle : &TOCYCLE-&TOMONTH/&TOYEAR"
"""Reseller BAN " "
"Recurring Charges Section - " "
"

SUM BASE_QTY AS 'Base Qty'
BASE_REVENUE AS 'Base Rev $'
PROR_QTY AS 'Prorated ,Qty '
PROR_AMT AS 'Prorated ,$ '
ARREAR_QTY AS 'Arrears ,Qty '
ARREAR_AMT AS 'Arrears ,$ '
TOTAL_REVENU AS 'Total Rev '
-* DEP_DESC AS 'Dependency,Description'
PP_SOC_TYPE NOPRINT
COMPUTE CA_AMT/D12=&CA_AMT; NOPRINT
COMPUTE CS_AMT/D12=&CS_AMT; NOPRINT
COMPUTE CC_AMT/D12=&CC_AMT; NOPRINT
COMPUTE TOT_C_AMT/D12=&TOT_C_AMT; NOPRINT

BY BAN NOPRINT
BY PP_SOC_TYPE NOPRINT
BY HIGHEST SSOC_LEVEL NOPRINT

Welcome to FocalPoint. Please use the </> button to add "code" tags in your post and put your code between these tags.

You problem is most likely due to a format issue with one or more of these selection statements.

WHERE BAN EQ &BAN
AND CYCLE_CODE GE &FROMCYCLE AND CYCLE_CODE LE &TOCYCLE
AND MONTH GE &FROMMONTH AND MONTH LE &TOMONTH
AND YEAR GE &FROMYEAR AND YEAR LE &TOYEAR

Are BAN, CYCLE_CODE, MONTH, YEAR numeric fields? If not, you need quotes, something like this:

WHERE BAN EQ '&BAN'

Yes BAN is numeric field and is set as below

-RBL
-*----
-*READ B1 &BAN.I9.
-READ B1 &BAN.D12.
-GOTO CONTPROC;
-*----
-RNB
-*----
-*READ NB1 &BAN.I9.
-READ NB1 &BAN.D12.
-*----
-CONTPROC
-*----
-IF &IORETURN EQ 1 GOTO MARS;
-SET &S_BAN.&J=&BAN;
-SET &J=&J+1;
-GOTO STEP8;

-*------
-MARS
-*------
-SET &MAX=&J;

-SET &J=0;

-*------
-STEP4
-*------
-SET &J=&J+1;
-IF &J EQ &MAX GOTO CHKTL;
-SET &BAN=&S_BAN.&J;
-GOTO STEP1;