help

[Laura Brody]

Quoting "Jay R. Ashworth" <jra at baylink.com>:

> On Fri, Nov 09, 2007 at 11:36:24AM -0800, Enrique Arredondo wrote:
>> 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.
>
> You're working with base 36 integers.  I assume you're using the
> traditional increment approach where:
>
> 08..09..0a..0b...0y..0z..10..11...19..1a.... ?
>
> There's no native method of dealing with base-36 numbers in filepro,

  **BZZZZT** Wrong! Thanks for playing .....

Page 32 of Laura's Quick Reference Guide for filePro v5.0 says:

   v4.5 BASE() Returns the value of numb in the numeric base result_base
("2"-"36")
    n=BASE(n,num_base,[result_base])
    The third parameter is optional, if omitted, the default is "10".


-- 
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 --------+