Re: SELECTing first x results (a FAQ?)

Peter Lancashire wrote: > > You can create your own counter for this in SPL. I have just been > mucking about with this today to solve a slightly different problem but > an adaptation of my solution may work for you. > > This is a work in progress, please test it first! > <snip> Sorry about commenting on my own posting but I realised some time later that the iterator() procedure I posted yesterday could be used in an unsafe way: if you use it in a WHERE clause, I can guarantee that chaos will result as the returned values will not match the returned values from the select list. -- 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 AND the release notes. 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/