Online Help

Previous moves the row cursor maintained within result to the previous row in the table.

If the new Row is a valid row containing table data, Previous returns true. If the new row is before the first row of the table, Previous returns false.

The row cursor can be moved forward using the Next command.

$\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} \\ \left(\right) \\ \mathbf{end}\mathbf{do}\: \end{gathered}$$

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

$''hamster''$

$''pig''$

$''parrot''$

$''lizard''$

$''snake''$

$''horse''$

$''rat''$

$''cat''$

$''dog''$

$''fish''$