Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there an array size limit for vfp7?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
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:
01488853
Vues:
57
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
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform