Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there an array size limit for vfp7?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Is there an array size limit for vfp7?
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01488846
Message ID:
01488846
Vues:
118
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform