|
Connection:-CreateStatement - create a statement module
|
|
Calling Sequence
|
|
connection:-CreateStatement(opts)
|
|
|
Parameters
|
|
|
connection
|
-
|
Connection module
|
|
opts
|
-
|
(optional) equations of the form option=integer where option is one of timeout, maxrows or maxfieldsize
|
|
|
|
|
|
Description
|
|
|
•
|
CreateStatement opens a Statement module. This Statement module can be used to send arbitrary SQL statements to the database.
|
|
•
|
CreateStatement accepts as optional arguments the same options that can be set with Statement:-SetOptions.
|
|
|
The number of seconds the client waits for a response from the database.
|
|
|
The maximum number of rows a query returns.
|
|
|
The maximum number of bytes that a column uses to store character or binary data. This only applies to columns of type BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR. If the limit is exceeded then the extra data is ignored.
|
|
|
|
Examples
|
|
|
>
|
![driver := Database[LoadDriver]()](/support/helpjp/helpview.aspx?si=7890/file05675/math106.png)
|
|
>
|
|
Create a statement with no options specified.
|
>
|
|
|
| (1) |
Create statements with various options.
|
>
|
 
|
|
|
Download Help Document
Was this information helpful?
