Re: Ordering of result columns

Lee Wan Ling wrote: > > But I have some cursors declared for update and INFORMIX does not allow the use of > > order by when you have cursors declared for update! Just select rowid in addition to the columns you need and update by rowid, it is just as fast as using a cursor for update and you can drop the FOR UPDATE clause and put the ORDER BY back in. > David Williams wrote: > > > > > > > Start adding order by , it is the only way.. > > -- > > David Williams > >