Jump to content
Sign in to follow this  
Henry Olive

Attempted Update During Read Only Transaction

Recommended Posts

I made backup an old database then i restored it in new Interbase-2020

when i try to test the new Truncate function i got 

"Attempted Update During Read Only Transaction"   error msg.

I checked my database's properties in IbConsole they are like below

ReadOnly=False,  WriteMode=Synchronous

What could be the problem ?

Thank You



Share this post

Link to post

The message is about the transaction. Check settings of transaction

Share this post

Link to post

We don't know the basic thing. How to connect to a DB. Which components do you use.

Share this post

Link to post

Because Precommitted transactions do not get a transaction ID and can basically run forever without causing growth in the TIP page, the wisql window in IBConsole defaults to read-only transactions (not to be confused with a read-only database).


To change this click Transactions | Options and just switch the radio button from read to write.  If you always want it to be a writeable transaction check the Set as Default at the bottom.

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this