Online Help

Close frees the resources associated with preparedstat. This happens automatically when preparedstat is garbage collected; however, you can call Close to release the resources immediately.

Any descendant modules of preparedstat are closed when preparedstat is closed. (A module is a descendant of a parent module if it is returned by one of the parent module's exports or if it is a descendant of one of the parent module's descendants.)

$\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{pstat}≔\mathrm{conn}:-\mathrm{CreatePreparedStatement}\left(''SELECT\; *\; FROM\; animals''\right)\:$

$\mathrm{res}≔\mathrm{pstat}:-\mathrm{Execute}\left(\right)\:$

$\mathrm{stat}:-\mathrm{Close}\left(\right)$

$\mathrm{res}≔\mathrm{pstat}:-\mathrm{Execute}\left(''SELECT\; *\; FROM\; animals''\right)\:$

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