IsolationLevel Property
The IsolationLevel property sets or returns the transaction types permitted when you reference an Impromptu query definition file(.iqd).
Syntax
IqdDataSource .IsolationLevel
Applies To
Discussion
Set this property to one of the following transaction settings.
| Long value |
Description |
|---|---|
| 0 |
Default. Uses the isolation level that was originally specified when the data source was created. |
| 1 |
ReadUncommitted. Makes changes made by other transactions immediately available to a transaction. |
| 2 |
ReadCommitted. Allows a transaction access to only those rows that have been committed by other transactions. |
| 3 |
CursorStability. Prohibits other transactions from updating the row upon which a transaction is positioned. |
| 4 |
ReproducibleRead. Ensures that rows selected or updated by a transaction will not be changed by another transaction until the first transaction is complete. |
| 5 |
PhantomProtection. Prohibits access by a transaction to rows inserted or deleted since the start of the transaction. |
| 6 |
Serializable. Ensures that a set of transactions executed concurrently produce the same result as if they were performed sequentially. |
Type
Long
Access
Read/Write
Examples
datasource
= model.DataSources.Add(xtrObjectType.trIqdDataSource)datasource.IsolationLevel
= 0