Re: ERROR -246 ?

timothy.hood@sltrib.com (Timothy Hood) wrote: >F> From: Frederic_Bouquet@ascus.com (Frederic Bouquet) >F> A user modifies a row within a transaction. Before the end of the transactio > > another user wants to select this row. Instead of getting the old value, he > > receives the error code : > > -246 Could not do an indexed read to get the next row. >F> What's wrong ? Any help would be appreciated. >I believe the row is not unlocked until the transaction fully completes >in case the transaction fails at some later point so Informix can "undo" >the row update. What you will also find is that you will also be unable to access the row accessed by the next indexed position. INFORMIX has stated that this is not a bug but a 'feature' of the software and it is the responsibility of the programmer to code arround this. Eddie --------------------------------------------------------------------------- | Eddie Hulme ehulme@ironbdge.demon.co.uk | ---------------------------------------------------------------------------