Re: ROWID Question

Posted in 1996

Nils Myklebust — Fri, 08 Nov 1996 18:42:38 GMT — source: Informix-list mailing list archive (1991-1998)

Tim Porreca <tporreca@colburn.com> wrote: :In 7.2 DS, if I have a table in which I NEVER delete records, will the :ROWIDs be added sequentially? We have notes tables which need to be :retrieved in formcode in the order they were entered. In which case you add a serial column that will automatically get sequencially increasing numbers as rows are added. Forget about any use of ROWID. It's too foreign to relational databases to be of much use. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org