Re: Reversal of Records

Posted in 1991

John Baker, Lex-Blue Grass Army Depot — Mon, 2 Dec 91 9:09:32 EST — source: Informix-list mailing list archive (1991-1998)

Quoting Will Hartung (uunet!la4gen!villy): > You'll notice that the records are in the order of ENTRY, not the order > of the data (assuming the your 1,2,3,4 is not your serial field). > If you look at the SERIAL field data on those records, they probably read > something like: > > Record Serial > 1 1 > 3 3 > 4 4 > 5 5 > 2 6 < -- Note this > > Using the index on the SERIAL field puts them in the ORDER of the SERIAL > field (in this case 1,3,4,5,6) rather than your data (1,2,3,4,5). What you've described is indeed what happened. If I had paid closer attention to the value of the Serial column, I probably would have figured this out on my own. Thanks for replying. John Baker =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= John Baker, USAISC - Lex, Lexington - Blue Grass Army Depot, Lexington, KY (jbaker@lexington-emh2.army.mil) Phone: (606) 293-3644, 293-3743 DSN: 745- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=