Hi Steven
>I have tried this and it works. However, it is slow to pull down 64,000 plus records. Maybe I am doing somthing wrong.
Ouch! It probably would be, even if all you bring down are the key values (which I assume you is what you are doing anyway).
Maybe you can limit the result set to a few hundred records at a time by passing in a key value and using a BETWEEN statement (i.e. keyval -250 to keyval +250).
Then when they hit 'next' you can check the local cursor, if they're at the end, re-query for the next block of 500 records. That should be pretty quick and surely they won't be scrolling through more than a few tens of records anyway?
----
Regards
Andy Kramek