Renders a paged SELECT statement

Parameters

pageIndex

The zero based index of the page to be returned

pageSize

The size of a page

totalRowCount

Total number of rows the query would yeild if not paged

query

Query definition to apply paging on

Return Value

Generated SQL statement

Remarks

Generating pagination SQL is different on different databases because every database offers different levels of support for such functioanality. Some databases (SqlServer 2000) require the programmer to supply the total number of rows to produce a page. If your renderer does not use the totalRowCount parameter, please state so in your implementation documentation.

See Also

ISqlOmRenderer Interface | Reeb.SqlOM.Render Namespace

---