Statement - Maple Programming Help

Home : Support : Online Help : Connectivity : Database Package : Statement : Database/Statement/SetOptions

Statement

 SetOptions
 set options of a Statement module

 Calling Sequence statement:-SetOptions( opts )

Parameters

 statement - Statement module opts - (optional) equations of the form option=integer where option is one of timeout, maxrows, or maxfieldsize

Description

 • 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.

Examples

 $\left[{\mathrm{timeout}}{=}{0}{,}{\mathrm{maxrows}}{=}{0}{,}{\mathrm{maxfieldsize}}{=}{8192}\right]$ (1)
 $\left[{\mathrm{timeout}}{=}{10}{,}{\mathrm{maxrows}}{=}{0}{,}{\mathrm{maxfieldsize}}{=}{8192}\right]$ (2)
 $\left[{\mathrm{timeout}}{=}{10}{,}{\mathrm{maxrows}}{=}{20}\right]$ (3)
 $\left[{\mathrm{timeout}}{=}{10}{,}{\mathrm{maxrows}}{=}{20}{,}{\mathrm{maxfieldsize}}{=}{1000}\right]$ (4)