GotoRow moves the row cursor maintained within result to the row indexed by offset.  If offset is positive, then it is interpreted to be relative to the beginning of the table.  GotoRow(1) is the first row, GotoRow(2) is the second, and so forth.  If offset is negative, then it is interpreted to be relative to the last row of the table.  GotoRow(-1) is the last row, GotoRow(-2) is the second to last row.

The index of the current row can be obtained by calling GetRowIndex.

GotoRow accepts one optional argument.

relative = boolean

If relative is true, then offset is interpreted as relative to the current row.  For example, GotoRow(1,relative=true) is equivalent to Next.

Setting the row cursor to a location beyond the ends of the table results in the cursor getting set to the row before the first data row or the row after the last data row.

$\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{ToMaple}\left(\mathrm{output}='\mathrm{Array}'\right)$

$\left[\begin{array}{c}''fish''\\ ''dog''\\ ''cat''\\ ''rat''\\ ''horse''\\ ''snake''\\ ''lizard''\\ ''parrot''\\ ''pig''\\ ''hamster''\end{array}\right]$

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

$\mathrm{true}$

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

$''hamster''$

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

$\mathrm{true}$

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

$''fish''$

$\mathrm{res}:-\mathrm{GotoRow}\left(1\,\mathrm{relative}=\mathrm{true}\right)$

$\mathrm{true}$

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

$''dog''$

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

$\mathrm{true}$

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

$''pig''$

$\mathrm{res}:-\mathrm{GotoRow}\left(-1\,\mathrm{relative}=\mathrm{true}\right)$

$\mathrm{true}$

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

$''parrot''$

$\mathrm{res}:-\mathrm{GotoRow}\left(-4\,\mathrm{relative}=\mathrm{true}\right)$

$\mathrm{true}$

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

$''rat''$

$\mathrm{res}:-\mathrm{GotoRow}\left(2\,\mathrm{relative}=\mathrm{true}\right)$

$\mathrm{true}$

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

$''snake''$

$\mathrm{res}:-\mathrm{GotoRow}\left(10\,\mathrm{relative}=\mathrm{true}\right)$

$\mathrm{false}$

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

$\mathrm{false}$