Re: SQL problem

In article <3598E612.2B2F@bayer.co.uk>, Peter Lancashire <Peter.Lancashi re.PL1@bayer.co.uk> writes >David Williams wrote: >> E.g. if FETCH ABSOLUTE 100 works and 200 works then generally speaking >> the cursor will have >500 rows so rather than 400 try 500. If that >> works generally the cursor will have >1500 rows so try curosr position >> 1500 next!! >> >> -- >Yes, you could do this if you enjoy a challenge. I would prefer > FETCH LAST my_scroll_cursor ... But SQLCA.SQLEERD[2] is NOT guaranteed to be set after a select... -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care