Re: last insert

mars1972@my-deja.com wrote: > > Also, I had heard that ROWIDs were going away and wouldn't be supported > anymore. I don't know if this is actually true, but... I think that's a mixture of confusion. The rowid in IDS represents the physical location in terms of the page number and the slot number. For fragmented tables this is not always unique. So rowid in general is not useful for finding the last row inserted or indeed finding a row at all. The bit that's probably not supported is using rowid to uniquely identify a row in a fragmented table. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+