Re: How big is my result set?

Keep in mind that whenever you use a count(*) to determine how many records comply to the selection criteria you performace degrades tremendously because the count(*) needs to go thru the entire table to do it's job, just as the 'select' would. And there is no need for it. *Assuming* you are using a limited array to fill every time 'next (page)' is hit you can simply do a ' fetch next' to determin whether you are at the end of your 'fille array' selection. If so set a flag (i.e. ' end_of_table' to true) and use that to disable your keys. Don't forget to do a ' fetch previous' if you DID NOT reach the end of the table. Success Robert A. Reissaus RISDI Ibm/Informix consultants Amsterdam, the Netherlands ra.reissaus@risdi.com www.risdi.com