First moves the row cursor maintained within result to the first row of the table.

First accepts one optional argument.

before = boolean

If before is true, then the row cursor is moved to the row before the first row containing data, that is, the same location as when a Result module is created.

First returns true if the new row indicated by the cursor is a row containing data.  When called with before=true, First always returns false.

$\mathrm{driver}≔{\mathrm{Database}}_{\mathrm{LoadDriver}}\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)\:$

$\mathbf{while}\mathrm{res}:-\mathrm{Next}\left(\right)\mathbf{do}\mathrm{res}:-\mathrm{GetData}\left(1\right)\mathbf{end\; do}\:$

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

$\mathrm{true}$

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

$''fish''$

$\mathrm{res}:-\mathrm{First}\left(\mathrm{before}\=\mathrm{true}\right)$

$\mathrm{false}$

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

$\mathrm{true}$

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

$''fish''$