PreparedStatement:-GetOptions - get options of a PreparedStatement module
|
Calling Sequence
|
|
preparedstat:-GetOptions( opts )
|
|
Parameters
|
|
preparedstat
|
-
|
PreparedStatement module
|
opts
|
-
|
(optional) name; the option to get, one of timeout, maxrows, or maxfieldsize
|
|
|
|
|
Description
|
|
•
|
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
|
|
the number of seconds preparedstat waits for a query to execute. If the limit is exceeded, an error is raised.
|
|
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.
|
|
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.
|
|
|
Examples
|
|
>
|
|
| (1) |
>
|
|
| (2) |
>
|
|
| (3) |
>
|
|
| (4) |
|
|
Download Help Document
Was this information helpful?