Focal Point
define file

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2761061561

April 25, 2006, 02:52 PM
Evgenia
define file
Hi everybody,
Here is a piece of code:
DEFINE FILE S_REP_ANALYSIS
CCODE/I3 = COMPANY_CODE;
DCODE/I3 = DIVISION_CODE;
LASTN/A15 = GETTOK(SALES_REP_NAME, 20, -1, ' ', 15, LASTN);
FIRSTN/A15 = GETTOK(SALES_REP_NAME, 20, 1, ' ', 15, FIRSTN);
SRLIST/A70 = ',' || '"' || LASTNM || '"' || ',' || '"' || FIRSTNM || '"' || "," || '"' || SALES_REP_ID || '"' || ',' || '"' || EDIT(DCODE) || '"' || ',' || '"' || EDIT(CCODE) || '"';
END
TABLE FILE  S_REP_ANALYSIS
BY SRLIST
ON TABLE SAVE AS SALESREP FORMAT ALPHA
END 


...and it gives me the following error
"(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: LASTNM"

DIVISION_CODE, COMPANY_CODE, SALES_REP_NAME, SALES_REP_ID are fields in S_REP_ANALYSIS. I am trying to parse SALES_REP_NAME into last name and first name. SALES_REP_NAME is an A20V field, SALES_REP_ID is an A15V field.

What am I doing wrong?
Thank you very much
April 25, 2006, 03:07 PM
Spence
you have created a field named lastn in your define and not lastnm


WF 8 version 8.2.04. Windows.
In focus since 1990.
April 25, 2006, 03:21 PM
Evgenia
oops..
Thanks.I am very embarrassed. I thought I checked and overchecked it, but now I realize that I was checking within GETTOK statement.
Thanks again.