For Harland Macia

Can't reach you directly > > Problem: > I want current data using a scroll cursor. > > Question: > Can someone help me? > > Other: > I'm using Online 5.01 and esql/C. > > I need the same functionality of the scroll cursor (fetch next, prev, top, > bottom). I thought that the isolation level would effect the data being shown in > the form, but because the scroll cursor uses a temp table this takes away the > usefulness of Online using share memory to read the most current data. > > Is informix going to fix this in the next release of Online? > Use the cursor to retrieve rowid and nothing else. When the user does a next/prev/whatever, use the rowid returned from the fetch xxxx to actually retrieve the row. Guarantees fresh data. Of course you still have to worry about someone deleting a row (which you did before anyway). j. _____________________________________________________________________________ Jack Parker - Contractor | Hewlett Packard, BSMC Boise, Idaho, USA| If you keep staring at it like that, jparker@hpbs2561.boi.hp.com | your nose is going to grow (208) 323-5388 (W) (208) 384-1623 (H) | into the bark. ^^^ 396 as of 6:30am April 29th _____________________________________________________________________________