IBconsols = attempted update during read-only transaction 에러해결방법

IBconsols = attempted update during read-only transaction 에러해결방법

 

IBConsole 창에서 Tools - Interactive SQL 창을 오픈한다.

Interactive 창에서 Transactions-Option 클릭

해당 창에서 Access mode 를 Write 로 설정한다.

원인은 읽기 전용으로 설정해놔서 쿼리가 수정/저장이 안된것이다

 

관련 글

IBConsole in InterBase XE7 has changed the "default transaction mode"; it is set to "read only" transaction by default.

If you are planning to execute UPDATE statements from IBConsole's SQL window, please change you transaction

mode before running any UPDATE.

In the SQL window, select menu item Transactions | Options. Change "Access mode" to "Write", and "Isolation level"

to "Concurrency"; and, save it. Any further launch of SQL window will respect this setting.