April 25, 2006, 02:52 PM
Evgeniadefine 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
Spenceyou have created a field named lastn in your define and not lastnm
April 25, 2006, 03:21 PM
Evgeniaoops..
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.