Re: autonumber question

Posted in 1999

Octav Chiriac — Sat, 20 Mar 1999 20:20:08 +0200 — source: Informix-list mailing list archive (1991-1998)

The max value for a serial columns is 2147483647. If your serial value will reach this limit it will go again to 1. Best Regards, Octav On Sat, Mar 20, 1999 at 11:18:56AM -0500, Yan Zhu wrote: > hi all: > If I use the autonumber as a key, exactly how far does it go? What's > the upper limit for a autonumber index? > What if I have 1 million record and continously adding to it? Also, I > realize that if you delete a record, it won't use the same autonumber to > number the next record, so it won't help if I delete the previous > records? bascially, I am afraid that one day I'll find out I can't add > any more records because of that. > > thanks > > yan > > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com