SetOptions sets various options that affect the behavior of preparedstat.

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

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

SetOptions does not return anything.

The following are the options that can be passed to SetOptions.

timeout = integer

the number of seconds preparedstat 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{pstat}≔\mathrm{conn}:-\mathrm{CreateStatement}\left(\right)\:$$\mathrm{pstat}:-\mathrm{GetOptions}\left(\right)$

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

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

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

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

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

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

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