connection.transsupport
Description
The transsupport property of the
connection object type, indicates the level of
transaction support provided by the database engine connected to.
NOTE: transsupport is a read-only property of type
integer.
Example
For example, if conn is a connection object reference with an open connection
to a database engine then the following:
conn.transsupport
contains the level of transaction support provided by the database engine. The possible values
of this property are:
- sql_tc_none - Transactions are not supported.
- sql_tc_dml - Transactions containing Data
Manipulation Language (DML) statements are supported. Transactions containing Data Definition
Language (DDL) statements cause an error. DML statements include SELECT, INSERT, UPDATE,
DELETE. DDL statements include CREATE, and DROP.
- sql_tc_all - Transactions containing both DML
and DDL statements are supported.
- sql_tc_ddl_commit - Transactions
containing DML statements are supported. DDL statements encountered in transactions cause the
transactions to be committed.
- sql_tc_ddl_ignore - Transactions
containing DML statements are supported. DDL statements encountered in transactions are
ignored.
Portability
Operating Systems: All
Standard Pascal: No