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.