dblastrow

Returns the number of the last row in the row buffer.

Syntax

DBINT dblastrow ( PDBPROCESS dbproc );

where

dbproc

Is the DBPROCESS structure that is the handle for a particular workstation/ SQL Server process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.

Returns

The number of the last row in the row buffer. The first row returned from SQL Server is number 1.

Remarks

If you aren't buffering rows, dbfirstrow, dbcurrow, and dblastrow always have the same value. If you have enabled buffering by setting the DBBUFFER option, dblastrow returns the number of the last row in the row buffer, which might not be the last row available from the server. Use this return value with a call to dbgetrow. For example, if a query returns 100 result rows and you read 20 rows into the buffer using dbnextrow, dblastrow returns 20 regardless of which row is current. As the application processes and clears rows from the buffer using dbclrbuf and more data is read from the server using dbnextrow, dblastrow returns the number of the result row stored in the highest (newest) buffer location.

See Also

dbclrbuf, dbcurrow, dbfirstrow, dbgetrow, dbnextrow, dbsetopt; Bulk-Copy Functions, and DB-Library Options