GetOptions gets the values of options that affect the behavior of statement.

All the options that can be read with GetOptions can be set by calls to SetOptions or when the Statement is created by CreateStatement.

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

GetOptions recognizes the following options.

timeout

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

maxrows

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

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 GetOptions with no arguments returns the current values of all the arguments that GetOptions can query.

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