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}\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)\:$

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

$\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''$