Attempted Update During Read Only Transaction

[Henry Olive 5]

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

 

 

[Stano 143]

The message is about the transaction. Check settings of transaction

[Henry Olive 5]

Thank you Stano

Where is the Transaction Settings ?

[Henry Olive 5]

I saw the settings it was in InteractiveSQL section

[Stano 143]

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

[Jeff Overcash 2]

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.

[Guest]

better "helper" is your Help System!

http://docwiki.embarcadero.com/InterBase/2020/en/Overview_of_Command-line_Tools

http://docwiki.embarcadero.com/InterBase/2020/en/Interactive_Query