Re: SQL problem

Posted in 1998

Peter Lancashire — Wed, 01 Jul 1998 13:39:59 +0100 — source: Informix-list mailing list archive (1991-1998)

David Williams wrote: > > 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 > Yes, my oversight. Apologies. Must RTFM even more... But the database knows the information - why won't it tell us? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/