Select payroll_tbl.location, ; &&more than 1 rec can exist due to promotions payroll_tbl.division, ; payroll_tbl.unit, ; payroll_tbl.titleive, ; payroll_tbl.tanf, ; payroll_tbl.grant1, ; payroll_tbl.hourgrant1, ; payroll_tbl.grant2, ; payroll_tbl.hourgrant2, ; payroll_tbl.unempins, ; payroll_tbl.wrkcompins, ; payroll_tbl.retireperc, ; payroll_tbl.empstatus, ; payroll_tbl.realign_pct, ; payroll_tbl.unemp_ins_pct, ; payroll_tbl.wrk_comp_pct, ; payroll_tbl.dob, ; payroll_tbl.cntsnrdte, ; payroll_tbl.ctitle, ; payroll_tbl.health_ins, ; payroll_tbl.retiree_med, ; payroll_tbl.retire_type, ; payroll_tbl.zstep, ; payroll_tbl.prom_date, ; payroll_tbl.pextra, ; &&a__gen4(1,25) payroll_tbl.loc_long, ; payroll_tbl.div_long, ; payroll_tbl.unit_long, ; &&a__gen4(1,28) payroll_tbl.JPCFJH, ; &&a__gen4(1,29) payroll_tbl.JPCFTRMT ; &&a__gen4(1,30) from payroll_tbl into array a__gen4 ; where payroll_tbl.ssn == a1 and payroll_tbl.pp == c1however If I add one more item to end of select (payroll.warrant), it won't let me save the code and I get a message saying "Command contains unrecognized phrase/keyword".
Select payroll_tbl.location, ; &&more than 1 rec can exist due to promotions payroll_tbl.division, ; payroll_tbl.unit, ; payroll_tbl.titleive, ; payroll_tbl.tanf, ; payroll_tbl.grant1, ; payroll_tbl.hourgrant1, ; payroll_tbl.grant2, ; payroll_tbl.hourgrant2, ; payroll_tbl.unempins, ; payroll_tbl.wrkcompins, ; payroll_tbl.retireperc, ; payroll_tbl.empstatus, ; payroll_tbl.realign_pct, ; payroll_tbl.unemp_ins_pct, ; payroll_tbl.wrk_comp_pct, ; payroll_tbl.dob, ; payroll_tbl.cntsnrdte, ; payroll_tbl.ctitle, ; payroll_tbl.health_ins, ; payroll_tbl.retiree_med, ; payroll_tbl.retire_type, ; payroll_tbl.zstep, ; payroll_tbl.prom_date, ; payroll_tbl.pextra, ; &&a__gen4(1,25) payroll_tbl.loc_long, ; payroll_tbl.div_long, ; payroll_tbl.unit_long, ; &&a__gen4(1,28) payroll_tbl.JPCFJH, ; &&a__gen4(1,29) payroll_tbl.JPCFTRMT ; &&a__gen4(1,30) payroll_tbl.warrant; &&<<<<<<<<<<<<-============= I added this line from payroll_tbl into array a__gen4 ; where payroll_tbl.ssn == a1 and payroll_tbl.pp == c1any comments?