SetOptions sets various options that affect the behavior of statement.

All the options that can be set with SetOptions can also be set when statement is created by a call to CreateStatement.

An option's current value can be obtained by calling GetOptions.

SetOptions does not return anything.

SetOptions accepts the following options.

timeout = integer

The number of seconds statement waits for a query to execute.  If the limit is exceeded, an error is raised.

maxrows = integer

The maximum number of rows a query returns. If there are more than maxrows rows in the database that match the query, the extra rows are dropped.

maxfieldsize = integer

The maximum number of bytes a field of type BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, or LONGVARCHAR will use.  If a field needs more than this, it is truncated.

Calling SetOptions with no arguments raises an error.

$\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{stat}≔\mathrm{conn}:-\mathrm{CreateStatement}\left(\right)\:$$\mathrm{stat}:-\mathrm{GetOptions}\left(\right)$

$\left[\mathrm{timeout}=0\,\mathrm{maxrows}=0\,\mathrm{maxfieldsize}=8192\right]$

$\mathrm{stat}:-\mathrm{SetOptions}\left('\mathrm{timeout}'=10\right)\;$$\mathrm{stat}:-\mathrm{GetOptions}\left(\right)$

$\left[\mathrm{timeout}=10\,\mathrm{maxrows}=0\,\mathrm{maxfieldsize}=8192\right]$

$\mathrm{stat}:-\mathrm{SetOptions}\left('\mathrm{maxrows}'=20\right)\;$$\mathrm{stat}:-\mathrm{GetOptions}\left('\mathrm{timeout}'\,'\mathrm{maxrows}'\right)$

$\left[\mathrm{timeout}=10\,\mathrm{maxrows}=20\right]$

$\mathrm{stat}:-\mathrm{SetOptions}\left('\mathrm{maxfieldsize}'=1000\right)\;$$\mathrm{stat}:-\mathrm{GetOptions}\left('\mathrm{timeout}'\,'\mathrm{maxrows}'\,'\mathrm{maxfieldsize}'\right)$

$\left[\mathrm{timeout}=10\,\mathrm{maxrows}=20\,\mathrm{maxfieldsize}=1000\right]$