Re: Increment an alpha field by "1"

["Rory Hewitt" <roryhewitt@xxxxxxxxx>]

Well then I think my solution would work...

It might not be the 'best' and it doesn't use any fancy UNICODE or anything
like that, but I'm pretty sure it works.

Actually, Adam Glauser's version is probably slightly better since it
accesses array elements directly, so avoids the 'costly' %SUBST...

Rory

On Fri, May 23, 2008 at 10:05 AM, Peter Vidal <Peter_Vidal@xxxxxxxx> wrote:

> "So it's the AA01 - ZZ99 bit that will change? What happens if you try to
> exceed that limit? Can the first two characters (i.e. characters 3 and 4
> in
> the field name) ever be numeric? Can the last two ever be alpha? If the
> answer to both questions is no, then the following would work (I think):"
>
> In that case, we need to go from ZZ99 back to AA01.  This is because the
> life cycle of a mfg order is very small and by the time a number comes to
> existence, the old one is already in history files, so there is no "clash
> of keys" scenario...