Hi All,

I have a project that monitors a 3rd party chat program through API calls for the text from users in the chat room. One of the functions of my program allows a key word search through the database that my vb app is linked to. The problem is, sometimes the results are large enough to overload the input maximum for the chat program. I think its a total of 350 chars or so. And I want to paginate the resulting search responses so that 10 or 15 responses get sent back to the user at a time and that user can decide if they want more or not.

I believe I have several options for this but nothing seems to really work well. I think the easiest way to do this is to just take the first 15 results and send them, then say that there were more but you need to refine your search. Or I could check the record count and if its more than 10 or so send it to a separate process but that still leaves me with the pagination problem. I would like to allow the user to type say a "more" command and they get their responses in groups of 10 or 15 at a time till either they don't want any more responses and type a "stop" command or the resulting searched recordset is eof or a timer has elapsed.

The communication between my app and the chat room is not an issue. That works perfectly fine. The only problem I am running into is breaking up a resulting recordset into chunks that can be held for a specific user for a specific amount of time or the recordset is eof.

I am looking for any suggestions, examples, advice. I have considered sleepex or waitfor but not sure how they would react. I would really like the app active for other users while this search result is held for a specific user.