Re: Using ORDER BY with UPDATE CURSORS (SE 5.1)

At 02:29 pm 08/01/96 GMT, you wrote: } }Friends, } }I am facing a problem related to locking in INFORMIX SE 5.1. }When I DECLARE a CURSOR FOR UPDATE using ORDER BY, at the time of }opening, the Error is -365. This prevents me from using ORDER BY }with UPDATE CURSOR. Pls explain some way to get out of this }problem. } Use your current sorted cursor for retrieval only and then use a second cursor, based on the primary key of the record you wish to update, to actually perform the update. Dominic Pratt