If you look at the SQL properties of a table in EDB Manager you see the SQL definition, followed by the description:

DESCRIPTION ''
VERSION 1.00
READWRITE
UNENCRYPTED ....

In one random case, one of my tables in the database switched so the description read:

DESCRIPTION '[Properties]
LockIfCompleteSecurityLevel=101'
VERSION 1.00
READONLY
UNENCRYPTED ...

I had been running some ALTER SQL on the database and that specific table, but I had not switched this property.

--

1. I actually can't see how to alter the read-write property of a table in EDB. How is this done / Can it be done?

2. Does anyone know how I might have caused this to happen accidentally? I know this is a vague question, but I am really confused.

Adam


You are suffering from the wandering random mouse click syndrome (not to be confused with the wandering finger syndrome when using a touchpad or touch sensitive screen)!

More seriously there is a "mark table as read-only" checkbox on the create/alter table dialog in EDBManager. It only seems to work in create mode to set as read-only in 2.31b12. The reverse works fine. I'll download 2.31b13 and install to see if that works.


Roy Lambert

Adam


Same in b13.

The sql to do it is

ALTER TABLE "fred" READONLY

but when run it generates an error so I can only think it was done on table creation.

Roy Lambert

Thanks Roy!

You are 100% right, I knew I must have clicked something somewhere without realizing it.

Just couldn't see how to undo ...

Roy,

<< The sql to do it is

ALTER TABLE "fred" READONLY

but when run it generates an error so I can only think it was done on table creation. >>

This is now fixed, but I forgot to include the incident report in the release notes with the 2.32 release.  However, it's up on the site:

https://www.elevatesoft.com/incident?action=viewaddr&category=edb&release=2.32&incident=4779

Tim Young
Elevate Software
www.elevatesoft.com