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

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

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

GetOptions recognizes the following options

timeout

the number of seconds preparedstat 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{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]$