change TIL(Transaction Isolation Level) without disconect, is it possible?
Posted: 21.02.2022, 21:22
Is it possible to change TIL without reconect a database?
Using zeos 7.2 without reconnect changing properties:
isc_tpb_concurrency, isc_tpb_nowait, isc_tpb_read, isc_tpb_write, isc_tpb_consistency, isc_tpb_read_committed, isc_tpb_rec_version
does not have any affect until disconect and reconect.
Is it allright?
Why Zeos does not have ZTransaction like others(SQLdb, Firedac,...) to change TIL(Transaction Isolation Level). One TIL to read data and other for updates.
Using zeos 7.2 without reconnect changing properties:
isc_tpb_concurrency, isc_tpb_nowait, isc_tpb_read, isc_tpb_write, isc_tpb_consistency, isc_tpb_read_committed, isc_tpb_rec_version
does not have any affect until disconect and reconect.
Is it allright?
Why Zeos does not have ZTransaction like others(SQLdb, Firedac,...) to change TIL(Transaction Isolation Level). One TIL to read data and other for updates.