SqlCurRow&

Returns the number of the row currently being read.

Syntax

SqlCurRow& ( sqlconn% )

where

sqlconn%

Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

Returns

The number of the current row.

Remarks

SqlCurRow& returns the number of the row most recently read by SqlGetRow% or SqlNextRow%. When you do not turn on row buffering, SqlFirstRow&, SqlCurRow&, and SqlLastRow& always return the same value (the number of the current row).

Use SqlGetRow% to read rows from the row buffer. The first row SQL Server returns from the row buffer is number 1. The row number changes every time SqlNextRow% or SqlGetRow% returns SUCCEED. The row number is reset to 0 by each call to SqlResults%.

See Also

SqlClrBuf, SqlFirstRow&, SqlGetRow%, SqlLastRow&, SqlNextRow%, SqlSetOpt%; DB-Library for Visual Basic Options