help

[Laura Brody]

Quoting Enrique Arredondo <henry at vegena.net>:

> I can't think of a way to do this little project, maybe someone can shade
> me  some light:
>
> I need to display the next available number when the user inputs the first
> 2 digits , so filepro has to check on the database until it finds an
> available one.
>
> That is:
> User input
> ------
> 13      --- >   so I have to find from 00 thru ZZ and show which one is
> not on use.
>
> How can I increment from 00 all the way to ZZ so it shows me  13A4 or 13R9
> available.

   It sounds like you are using base 36 numbers. Is that correct?
How is the number stored? If it is * or alpha, you could just
push the values together and search for ge "1300".

   If you *really* need to increment from "00" to "ZZ", use
the BASE() function to convert to base 10, increment, then
convert it back to base 36.

   Does that help?
-- 
Laura Brody
+------------- Hudson Valley Computer Associates, Inc ----------+
| PO Box 859 120 Sixth Street    http://www.hvcomputer.com      |
| Verplanck, NY 10596-0859       Voice mail: Quoting Enrique Arredondo  
<henry at vegena.net>:

> I can't think of a way to do this little project, maybe someone can shade
> me  some light:
>
> I need to display the next available number when the user inputs the first
> 2 digits , so filepro has to check on the database until it finds an
> available one.
>
> That is:
> User input
> ------
> 13      --- >   so I have to find from 00 thru ZZ and show which one is
> not on use.
>
> How can I increment from 00 all the way to ZZ so it shows me  13A4 or 13R9
> available.
>
> Thanks
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>



-- 
Laura Brody
+------------- Hudson Valley Computer Associates, Inc ----------+
| PO Box 859 120 Sixth Street    http://www.hvcomputer.com      |
| Verplanck, NY 10596-0859       Voice mail: (914) 739-5004     |
+------ PC repair locally, filePro programming globally --------+