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.