>If you fix the typo in the command, there is still a limit of the array and it's about 65K elements. The limit is documented in Help.
>
>>Is there a array size limit of 30 or so when do a "select" clause to return values into array
>>
>>the following works
>>

>>            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 == c1
>>

>>
>>however 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 == c1
>>

>>
>>
>>any comments?
>>
>>nick


awh!!! I can't believe I missed that one. Thank again