Re: ESQL/C problem

Daniel Wright wrote: > [ stuff deleted ] > I'm confused, but be aware that when you open a cursor, Informix reads > the table. If you update a row in that table, the row is updated, BUT, > the cursor does not "see" this update until the cursor is re-opened. Doesn't this depend on isolation level and cursor mode? Generally ANSI cursor does not read the whole table. Scroll cursors do. OK, the order by will need the read of the filtered dataset, NOT the whole table. Couldn't you use an update cursor? -- Gabor Kincses (gabor@acm.org)