The number of rows the client should display to answer the end user's question.
Syntax
value = QueryCmd.DisplayRows
| Part | Description |
|---|---|
| value | A returned integer that indicates how many rows of information to return to the end user. |
| QueryCmd | An object variable that instructs the client to execute SQL. |
Applies To
Remarks
This property is read-only. If it is non-zero, then the user asked a question specifying a specific number or rows to be displayed. For example, if a user asks, "Show me the top five earners last year," this property returns 5. For some versions of SQL, for example Microsoft® SQL Server™ version 7.0 or higher, it is possible to use the SQL statement itself to limit the number or rows returned. For these versions of SQL, the DisplayRows property will always be zero. This property is needed for databases that do no support “top N” natively in SQL.
See Also
DisplayToUser Property, IgnoreError Property, SQL Property, TableCaption Property, SetDBMSr Method, TrueFalseAnswer Property