>I am working on a letter incrementing utility AKA A,B,C but with a 7 character field AKA AAAAAAA, AAAAAAB, AAAAAAC. So this procedure could have to loop up to 8,031,810,176 times, yea thats 8 billion times
>
>End users will just enter the starting letter / ending letter series and I want to figure out the rest
>
>My question / observation is
>
>a. I should use a table to store the results, right?
>
>b. I think I will have problems displaying the results, does anyone know if a object (Grid / Listbox / whatever) that can handle 8 billion records without a increased chance of my program or the PC bombing?
The biggest problem I see is that all that data is going to take memory. Assuming you start at AAAAAAA and go up to ZZZZZZZ, it will take 8,031,810,176 x 8 bytes = 64,254,481,408 bytes = 64Gb of memory. Consider that VFP tables can hold 2Gb. And you'll also need that 64GB (not MB) memory to show that up! :)
I hope you have
really big PCs... :)
Sylvain Demers