ODBCDatabase.SetConnectionAttribute
From Xojo Documentation
 |
This item was deprecated in version 2019r2. Please use ODBCDatabase.ConnectionAttribute as a replacement. |
Method
ODBCDatabase.SetConnectionAttribute(Attribute as Integer,Value as Integer)
Supported for all project types and targets.
Supported for all project types and targets.
Sets attributes that govern aspects of connections.
Notes
The attribute can be specified using the ODBCConstant constants. The value is only set after the connection is made. Only Integer attributes may be set with this method. To set a String attribute before the connection is made, see the Attribute property.
References
SQLSetConnectAttr ODBC function
Example
Setting an attribute to disable AutoCommit:
db.SetConnectionAttribute(ODBCConstant.SQL_AUTOCOMMIT, ODBCConstant.SQL_AUTOCOMMIT_OFF)