Hi,

I'm reciving the follwing error
(FOC063) WARNING. MATCH FIELDS HAVE SAME NAME BUT DIFFERENT FORMATS: QTR1
Please help

Regards
Pankaj

This message has been edited. Last edited by: Kerry,

Well the first thing you have to do is look at the masters of the files you are MATCHing.

Then check out the language manual and look up MATCH. It specifically states: "At least one pair of sort fields is required; field formats must be the same."

You can use a DEFINE to adjust the formats so that they are the same.

Hi Ginny,

Thanks for your quick response.
I'm new to webfocus coding,so i'm not doing any master files,we are doing all the codiing through sql.This following is the code which is throwing error,please help me out

-* File db10192.fex
-* File quartile.fex
SET NODATA = ''
-INCLUDE COMMON/COMMON
-*SET BASEURL = &&BURL;
-INCLUDE COMMON/CONNECTION
-INCLUDE db10190.fex
TABLE FILE SQLOUT
PRINT
*
ON TABLE HOLD AS A1
END
-INCLUDE common/norecords1
-IF &&GOTOEND EQ 'TRUE' THEN GOTO EXT ELSE GOTO CONT;
-CONT

TABLE FILE A2
PRINT QYR
QUARTILERANK AS 'QR
QTR
BY HIGHEST ROWNUM NOPRINT
WHERE QYR NE '' ;
ON TABLE SAVE AS QYRN FORMAT ALPHA
END
-RUN

SET ASNAMES = FOCUS
SET HOLDLIST =PRINTONLY

TABLE FILE HOLD
SUM COMPUTE DUMMY/I1= ; AS ''
BY QTR AS 'QR'
ACROSS QYR AS ''
WHERE QTR NE '' ;
ON TABLE HOLD AS DUMMYTAB FORMAT FOCUS
END

TABLE FILE HOLD
SUM
QUARTILENO AS ''
BY QUARTILERANK AS 'QR'
-*ACROSS ROWNUM NOPRINT AS ''
ACROSS QYR AS ''
-*ON TABLE SUBHEAD
-*"Quartile Rank Changes"
ON TABLE SET PAGE-NUM OFF
ON TABLE SET PAGE NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE HOLD AS TEST FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET CSSURL './css/mystyle.css'
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='A4',
SQUEEZE=ON,
ORIENTATION=PORTRAIT,

$
ENDSTYLE
END
MATCH FILE DUMMYTAB
BY QR
RUN
FILE TEST
PRINT *
BY QR
AFTER MATCH HOLD AS TEST OLD-OR-NEW
END


-SET &INDX =1;
-SET &COL ='' ;
-REPEAT NEWREC FOR &VAR FROM 1 TO &RECORDS
-READ QYRN NOCLOSE &QYR.A20
-SET &QYR.&INDX = EDIT(&QYR,'$$$$$$9999999') ;
-SET &COL = &COL |' '| &QYR.&INDX ;
-TYPE &COL
-SET &INDX = &INDX +1 ;
-NEWREC

TABLE FILE TEST
PRINT QR &COL
WHERE QR NE ''
ON TABLE HOLD AS TEST2
END

TABLE FILE TEST2
PRINT
*
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET CSSURL '/ibi_html/css/reportglobal.css'
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='A4',
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=DATA,
COLUMN=N1,
WRAP=.92,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N2,
WRAP=.92,
$
TYPE=DATA,
COLUMN=N3,
WRAP=.92,
$
TYPE=DATA,
COLUMN=N4,
WRAP=.92,
$
TYPE=DATA,
COLUMN=N5,
WRAP=.92,
$
TYPE=DATA,
COLUMN=N6,
WRAP=.92,
$
TYPE=DATA,
COLUMN=N7,
WRAP=.92,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N2 EQ '1',
$
DEFMACRO=COND0002,
MACTYPE=RULE,
WHEN=N3 EQ '1',
$
DEFMACRO=COND0003,
MACTYPE=RULE,
WHEN=N4 EQ '1',
$
DEFMACRO=COND0004,
MACTYPE=RULE,
WHEN=N5 EQ '1',
$
DEFMACRO=COND0005,
MACTYPE=RULE,
WHEN=N6 EQ '1',
$
DEFMACRO=COND0006,
MACTYPE=RULE,
WHEN=N7 EQ '1',
$
DEFMACRO=COND0007,
MACTYPE=RULE,
WHEN=N2 EQ '0',
$
TYPE=DATA,
COLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='WHITE',
BACKCOLOR='WHITE',
MACRO=COND0007,
$
DEFMACRO=COND0008,
MACTYPE=RULE,
WHEN=N3 EQ '0',
$
TYPE=DATA,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='WHITE',
BACKCOLOR='WHITE',
MACRO=COND0008,
$
DEFMACRO=COND0009,
MACTYPE=RULE,
WHEN=N4 EQ '0',
$
TYPE=DATA,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='WHITE',
BACKCOLOR='WHITE',
MACRO=COND0009,
$
DEFMACRO=COND00010,
MACTYPE=RULE,
WHEN=N5 EQ '0',
$
TYPE=DATA,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='WHITE',
BACKCOLOR='WHITE',
MACRO=COND00010,
$
DEFMACRO=COND00011,
MACTYPE=RULE,
WHEN=N6 EQ '0',
$
TYPE=DATA,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='WHITE',
BACKCOLOR='WHITE',
MACRO=COND00011,
$
DEFMACRO=COND00012,
MACTYPE=RULE,
WHEN=N7 EQ '0',
$
TYPE=DATA,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='WHITE',
BACKCOLOR='WHITE',
MACRO=COND00012,
$
TYPE=DATA,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='RED',
BACKCOLOR='RED',
MACRO=COND0006,
$
TYPE=DATA,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='BROWN',
BACKCOLOR='BROWN',
MACRO=COND0005,
$
TYPE=DATA,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='GREEN',
BACKCOLOR='GREEN',
MACRO=COND0004,
$
TYPE=DATA,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='YELLOW',
BACKCOLOR='YELLOW',
MACRO=COND0003,
$
TYPE=DATA,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='VIOLET',
BACKCOLOR='VIOLET',
MACRO=COND0002,
$
TYPE=DATA,
COLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='BLUE',
BACKCOLOR='BLUE',
MACRO=COND0001,
$
TYPE=DATA,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(225 240 249),
BORDER-BOTTOM-COLOR=RGB(225 240 249),
BORDER-LEFT-COLOR=RGB(225 240 249),
BORDER-RIGHT-COLOR=RGB(225 240 249),
$
TYPE=TITLE,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(225 240 249),
BORDER-BOTTOM-COLOR=RGB(225 240 249),
BORDER-LEFT-COLOR=RGB(225 240 249),
BORDER-RIGHT-COLOR=RGB(225 240 249),
BACKCOLOR=RGB(225 240 249),
$
TYPE=TITLE,
COLUMN=N1,
COLOR=RGB(225 240 249),
$
ENDSTYLE
END
-EXT

You are using master files in your MATCH statement, DUMMYTAB and TEST.

After the TABLE statements where you create each one, put a ? HOLD holdname and check out the format for the QR field. e.g.

TABLE FILE HOLD
SUM COMPUTE DUMMY/I1= ; AS ''
BY QTR AS 'QR'
ACROSS QYR AS ''
WHERE QTR NE '' ;
ON TABLE HOLD AS DUMMYTAB FORMAT ALPHA
END
-RUN
? HOLD DUMMYTAB

TABLE FILE HOLD
SUM
QUARTILENO AS ''
BY QUARTILERANK AS 'QR'
ACROSS QYR AS ''
ON TABLE HOLD AS TEST FORMAT ALPHA
END
-RUN
? HOLD TEST
-EXIT

BTW, you don't need to make these FOCUS files; a flat hold file will do. Also, you don't need to post then entire stylesheet if we aren't diagnosing styling. It just makes the post longer.

Anyway, post the results of the above code.