Online Help

GetRowIndex returns the index of the current row. Row indices range from $1$ to $n$, where $n$ is the total number of rows in the table.

If the current row is not a row containing data (the row before the first row, or the row after the last row) GetRowIndex returns 0.

GotoRow can be used to move to a row whose index was returned by GetRowIndex.

Deleting or inserting rows in the table may change the indices of rows. Do not assume that indices received before such an operation will index the same rows after.

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$$\mathrm{res}≔\mathrm{conn}:-\mathrm{ExecuteQuery}\left(''SELECT\; name\; FROM\; animals''\right)\:$$\mathrm{res}:-\mathrm{GetRowIndex}\left(\right)$

$0$

$$\begin{gathered} \mathbf{while}\mathrm{res}:-\mathrm{Next}\left(\right)\mathbf{do} \\ \mathrm{res}:-\mathrm{GetRowIndex}\left(\right) \\ \mathbf{end}\mathbf{do} \end{gathered}$$

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$\mathrm{res}:-\mathrm{GetRowIndex}\left(\right)$

$0$