Result:-GetRowCount - get the number of rows in the table
|
Calling Sequence
|
|
result:-GetRowCount( )
|
|
Description
|
|
•
|
GetRowCount returns the number of rows in result.
|
•
|
GetRowCount finds the number of rows by looking at the row index of the last row in the table. When working with very large tables and a fetchsize in place, GetRowCount may be a relatively expensive command to execute.
|
|
|
Examples
|
|
Create a Result.
>
|
|
| (1) |
>
|
![res := c:-ExecuteQuery("SELECT id FROM animals WHERE id BETWEEN 1 AND 2")](/support/helpjp/helpview.aspx?si=7928/file05705/math68.png)
|
| (2) |
>
|
![res := c:-ExecuteQuery("SELECT id FROM animals WHERE id BETWEEN 1 AND 4")](/support/helpjp/helpview.aspx?si=7928/file05705/math76.png)
|
| (3) |
>
|
![res := c:-ExecuteQuery("SELECT id FROM animals WHERE id BETWEEN 1 AND 8")](/support/helpjp/helpview.aspx?si=7928/file05705/math84.png)
|
| (4) |
>
|
![res := c:-ExecuteQuery("SELECT id FROM animals WHERE id = 11")](/support/helpjp/helpview.aspx?si=7928/file05705/math92.png)
|
| (5) |
|
|
Download Help Document
Was this information helpful?