TOTAL_ROWS

AIX HP-UX Linux OS/2 OS/390 OS/400 PTX SUN Win NT
X X X X X X X X X

Purpose

The total number of rows a query returns, no matter what the value of upper_limit for the TABLE language construct. For example, if RPT_MAX_ROWS is set to display a maximum of 20 rows, but the query returns 100 rows, this variable is set to 100 after ROW processing.

Operating system differences:

Language Environment Restriction: Use this variable only with the following database language environments:

Required: You must set DTW_SET_TOTAL_ROWS to YES to use this variable. See DTW_SET_TOTAL_ROWS for more information.

Examples

Example 1: Displays the total number of names found

%DEFINE DTW_SET_TOTAL_ROWS="YES"
 
%REPORT{
<h2>E-mail directory</h2>
<ul>
%ROW{
<li>Name: <a href="mailto:$(V1)">$(V2)</a><br />
Location: $(V3)
%}
</ul>
Names found: $(TOTAL_ROWS)
%}


[ Top of Page | Previous Page | Next Page | Index ]