Pageable Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

william_reinhold@doh.state.fl.us - 01 Jul 2005 17:56 GMT

wondered if there was anyway to have a query that returned a pageable
recordset. A table we use has over a million records and when
searching by name infopath can return a 1000+ records for a name like
smith, just wondered if there was a way to have the query return like
the first 50 then have a navbar to page through the remainder or next
previous navigation.

Reply to this Message

Alex [MSFT] - 01 Jul 2005 18:23 GMT

I recommend controlling the number of returned records via a dynamic query
(i.e. using SQL sub-statements like "LIMIT 50"). You will need to write some
custom code to generate this dynamic query, but the benefits will be huge -
you will have 50 records going through the wire at once, instead of 1000+.

Good luck,
Alex @ Microsoft

> wondered if there was anyway to have a query that returned a pageable
> recordset. A table we use has over a million records and when
> searching by name infopath can return a 1000+ records for a name like
> smith, just wondered if there was a way to have the query return like
> the first 50 then have a navbar to page through the remainder or next
> previous navigation.

Reply to this Message

william_reinhold@doh.state.fl.us - 01 Jul 2005 18:39 GMT

ok, thanks.
Sounds like I'd be better to figure how to incorporate a dynamic grid
that the user could set rows to return and then navigate accordingly.
I'm assuming from what you wrote that I would also have to write a
piece to handle paging forward and backward through the table at user
demand. ie, next 50, previous 50
I'm open ears for any suggestions to speed this up. we have an
enormous number of items to convert and would like to create a stock
routine that can do this by just modifying the connections and fields.

Reply to this Message