Change an Easycom server property.
bool i5_set_property (int Property, int / string Value, [resource connection])
Parameters
|
property
|
Symbolic value of the property to change.
|
|
|
Property |
Description |
|
|
I5_CURSOR_SENSITIVITY |
Change SQL cursor sensitivity. Valid values are: • 0 = I5_SQL_UNSPECIFIED – Cursors on the statement handle might make visible none, some, or all such changes depending on the cursor type. This is the default. • 1 = I5_SQL_INSENSITIVE – All valid cursors on the statement handle show the result set without reflecting any changes made to it by any other cursor. • 2 = I5_SQL_SENSITIVE – All valid cursors on the statement handle make visible all changes made to a result by another cursor.
|
|
|
value |
New value to set to the property.
|
|
|
connection |
Connection resource - result from i5_connect() or i5_pconnect()
|
|
Return
True if OK, false if failed.
Error returned
|
I5_ERR_DESC_WRONG_DATAOP |
41 |
Wrong operation on a data field of a description. |
|
I5_ERR_PARSEXML |
42 |
Internal error; please contact Aura Equipements. error number 42 |
|
I5_ERR_PHP_OPTIONSTYPE |
259 |
The type of " I5_OPTIONS_ALIAS" option must be x and not x |
|
I5_ERR_PHP_OPTIONSNUMBER |
260 |
Option number -1 is unknown. |
|
I5_ERR_PHP_TYPEPARAM |
262 |
Type of element x in parameter -1 must be y. Type z was provided. |
|
I5_ERR_PHP_DESC_EMPTY |
310 |
The description array is empty. |
Details
I5_CURSOR_SENSITIVITY
is changed for the next queries, until the next change of the property value.
It doesn’t affect the properties for already open queries.
Example
i5_set_property(I5_CURSOR_SENSITIVITY, 1);
if (!$ret)
{
print_r("i5_set_property error : ".i5_errormsg().'<br/>');
}
else
{
/* Next request is open with insensitive cursor */
$query = i5_query("SELECT * FROM EASYCOM/SP_CUST");
if (is_bool($query))
{
trigger_error("i5_query error : ".i5_errormsg(), E_USER_ERROR);
}
}
See also
i5_pclose
i5_connect
i5_pconnect