How to effectively use BeginRange / EndRange .. for records paging?

From: Mangesh Pawar (anonymous_at_discussions.microsoft.com)
Date: 06/24/04

  • Next message: Muhammad Mansoor: "Re: Restricting By Level Unique Name" 
    Date: Wed, 23 Jun 2004 17:34:04 -0700

    How to effectively use BeginRange / EndRange .. to get the
    result in pages?
    Say X no. of rows should be displayed per page and Rows
    per page is configurable

    Example:
    The MDX query returns 100,000 rows.
    Number of rows per retreived page is set to 25

    In this case, no. of rows is determined
    But to set Beginrange & EndRange.. one would require both
    number of rows & columns
    As number of columns that can be returned by the query is
    not known.
    .
    Will it be necessary to first execute the query (that
    returns 100,000 rows.. ) .. find the number columns..
    and then based row-column values set Beginrange / Endrange
    vaues

    Or is there a alternative method to pre-determine no. of
    Columns of a the MDX query

    Thanks

  • Next message: Muhammad Mansoor: "Re: Restricting By Level Unique Name"

    Relevant Pages

    • Re: Performance and BeginRange EndRange?
      ... How to effectively use BeginRange / EndRange .. ... The MDX query returns 100,000 rows. ... and then based row-column values set Beginrange / Endrange ...
      (microsoft.public.data.xmlanalysis)
    • Re: Odd BeginRange/EndRange behavior
      ... asking for exactly a range of cells can mean that the server doesn't have ... > While it would be possible to do an execute with Begin/EndRange only to ... BeginRange and EndRange ...
      (microsoft.public.data.xmlanalysis)
    • Re: Odd BeginRange/EndRange behavior
      ... If your BeginRange is 1 and EndRange is 40, ... All cells returned will fall into this rectangle. ... > The Query, below, produces approx 256 rows and 4 columns. ...
      (microsoft.public.data.xmlanalysis)
    • do something every 1000 records or so
      ... Ok, this could be a perfect exam question, but it isn't and i need a ... in a function i get 2 int parameters: ... public Vector findRecords(int beginRange, int endRange) ...
      (comp.lang.java.programmer)