HP3000-L Archives

October 1999, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Counting from 9999 to 000A?
From:
Twarns <[log in to unmask]>
Reply To:
Twarns <[log in to unmask]>
Date:
Wed, 13 Oct 1999 12:54:13 GMT
Content-Type:
text/plain
Parts/Attachments:
text/plain (32 lines) 
>Subject:      Counting from 9999 to 000A?

>
>Dear listers
>
>I am looking for an algorithmus, which solves the following problem and
>could be used within POWERHOUSE.
>
>We have an identifier which ranges from 1-9999 (but is stored as character
>in the database). We are about to reach the limit, so I would like to store
>000A after 9999 and so on, rather then changing all the database structures
>and depending programs.
>
>Thank you for any help,
>Friedrich
>
>
>
>
>
>
>

Do you want to go from 000A to 999A then 000B to 999B?  or go from 000A to 000Z
then 001A to 001Z.

You will need a record somewhere to keep the latest # and increment
accordingly.

Terry Warns
OakSoft Consulting

ATOM RSS1 RSS2