sasql_set_option

Sets the value of the specified option on the specified connection.

Prototype

bool sasql_set_option( sasql_conn $conn, string $option, mixed $value )

Description

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 sasql_num_rows function returns an estimate of the number of rows affected. 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 sasql_error or sasql_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

$conn – The connection resource returned by a connect function.

$option – The name of the option you want to set.

$value – The new option value.

Returns

TRUE on success or FALSE on failure.