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:
Stan Sieler <[log in to unmask]>
Reply To:
Stan Sieler <[log in to unmask]>
Date:
Wed, 13 Oct 1999 11:13:45 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (15 lines) 
Re:

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

I'd recommend going: 9998, 9999, A000, A001, A002 ...

why? Because it still sorts correctly (using a character sort).

--
Stan Sieler                                          [log in to unmask]
                                         http://www.allegro.com/sieler/

ATOM RSS1 RSS2