|
sqlanywhere_set_option
Prototype
bool sqlanywhere_set_option( resource link_identifier,
string option, string value )
Description
Sets the value of the specified option on the specified connection.
You can set the value for the following options:
| Name |
Description |
Default |
| auto_commit |
When this option is set to on, the database server commits
after executing each statement. |
on |
| row_counts |
When this option is set to false, the sqlanywhere_num_rows
function returns an estimate of the number of rows affected. If you want
to obtain an exact count, set this option to true. |
false |
| verbose_errors |
When this option is set to true, the PHP driver returns
verbose errors. When this option is set to false, you must call the
sqlanywhere_error or sqlanywhere_errorcode functions to get further
error information. |
true |
You can change the default value for an option by including the following
line in the php.ini file. In this example, the default value is set for
the auto_commit option.
sqlanywhere.auto_commit=0
Parameters
link_identifier The link
identifier returned by a sqlanywhere_connect function.
option The name of the option you
want to set.
value The new option value.
Returns
A positive Adaptive Server Anywhere link identifier on success, or an error and 0 on failure.
Example
The following examples show the different ways you can set the value of the
auto_commit option.
$result = sqlanywhere_set_option( $conn, "auto_commit",
"Off" );
$result = sqlanywhere_set_option( $conn, "auto_commit", 0 );
$result = sqlanywhere_set_option( $conn, "auto_commit", False );
Related functions
sqlanywhere_commit
sqlanywhere_error
sqlanywhere_errorcode
sqlanywhere_num_rows
sqlanywhere_rollback
|
