>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	

*------------------------------------------------------