Hello
Not trying to be rude, but I don't need a example, because I also have a "ignored letters" i.e. "B,C" box and "ignored sets of letters" i.e. "FAG", "PMS"
I have all the code in thought, but I am worrying about the number / lenght of the processes, running out of memory ya know stuff like that
Thanks for the reply
>>Hello all
>>
>>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?
>>
>>c. Would a for/endfor statement bomb having to loop 8 billion times?
>>
>>If anyone can think of any other issues they would be greatly appreciated
>
>See this example:
>
>CREATE TABLE AKA (Aka C(7))
>FOR lnI = 0 TO (26^7)-1
> INSERT INTO AKA (Aka) VALUES (_10to26(lnI))
>ENDFOR
>GO TOP
>BROWSE
>
>*------------------------------------------------------
>* FUNCTION _10to26
>*------------------------------------------------------
>* Funcion que pasa un número de base 10 a base 26
>* USO: _10to26(Numeric)
>* RETORNA: Caracter
>*------------------------------------------------------
>FUNCTION _10to26(tnNro10)
> #DEFINE lnLargo 7
> LOCAL lcNro26
> lcNro26 = ''
> DO WHILE tnNro10 >= 26
> lcNro26 = CHR(MOD(tnNro10,26) + 65) + lcNro26
> tnNro10 = INT(tnNro10 / 26)
> ENDDO
> lcNro26 = CHR(tnNro10 + 65) + lcNro26
> RETURN(PADL(lcNro26, lnLargo, "A"))
>ENDFUNC
>
>*------------------------------------------------------
>