I get this error on my define and Im not really sure why, Im pretty sure this worked before.

0 ERROR AT OR NEAR LINE 28 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC260) AN OPERATION IS MISSING AN ARGUMENT
0 ERROR AT OR NEAR LINE 31 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC260) AN OPERATION IS MISSING AN ARGUMENT
0 ERROR AT OR NEAR LINE 34 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC260) AN OPERATION IS MISSING AN ARGUMENT
0 ERROR AT OR NEAR LINE 37 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC260) AN OPERATION IS MISSING AN ARGUMENT
0 ERROR AT OR NEAR LINE 40 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: Ben64
0 ERROR AT OR NEAR LINE 77 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: NHRDIST.NHRDIST.Deduction
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

here is the code.

DEFINE FILE NHRDIST
run_by_fund /A13='&fund_option.(,).Run with funds?.';
payroll_type /A15='&payroll_option.(,,).Select type of payroll.';
BDCA_Group /A2=EDIT(NHRDIST_BDCA_CODE,'99$');
name/A25=SPRIDEN_LAST_NAME||', '||SPRIDEN_FIRST_NAME;
Deduction/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HEEL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HEEL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben64/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben79/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%2' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%2' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben131/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%3' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%3' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
ben_total/D12.2=Ben64 + Ben79 + Ben131;
....


Again, not really sure why this errors...nothing has changed as far as I know, but I dont manage the server

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

 run_by_fund /A13='&fund_option.(,).Run with funds?.';
payroll_type /A15='&payroll_option.(,,).Select type of payroll.' 

This really worked in the DEFINE? Do you get prompted for it?

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

let me try this again.....html putting in some weird characters....

DEFINE FILE NHRDIST
run_by_fund /A13='&fund_option.(<With Funds,With Funds>,<Without Funds,Without Funds>.Run with funds?.';
payroll_type /A15='&payroll_option.(<Adjustment,Adjustment>,<Original Event,Original Event>,<Both,Both>.Select type of payroll.';
BDCA_Group /A2=EDIT(NHRDIST_BDCA_CODE,'99$');
name/A25=SPRIDEN_LAST_NAME||', '||SPRIDEN_FIRST_NAME;
Deduction/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HEEL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HEEL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben64/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben79/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%2' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%2' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
Ben131/D12.2=IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%3' THEN NHRDIST.NHRDIST.NHRDIST_AMT * -1
ELSE IF NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%3' THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;
ben_total/D12.2=Ben64 + Ben79 + Ben131;

Please surround your code with CODE tags.

And can you run just the DEFINE setion, with &ECHO=ON, and post the output?

You need to wrap things around in parenthesis so you don't get that error. Like this:

Ben64/D12.2=IF (NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'D' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1') THEN (NHRDIST.NHRDIST.NHRDIST_AMT * -1)
ELSE IF (NHRDIST.NHRDIST.NHRDIST_DR_CR_IND EQ 'C' AND NHRDIST.NHRDIST.NHRDIST_RUCL_CODE EQ 'HERL' AND NHRDIST.NHRDIST.NHRDIST_BDCA_CODE LIKE 'R%1') THEN NHRDIST.NHRDIST.NHRDIST_AMT
ELSE 0;

it has to do with the

* -1

took this out and it doesnt error....the DEFINE editor doesnt even let me do it....

really weird, because I know ive done this before.

Do this all the time, BUT, you need to do it this way:

* (-1)

this was it! Thanks Tom!

I swear Ive done it without the (), owell it works now!