#295 Can't save fiel description

[Marcio Novaes]

I can't save the description field. Says that update on system tables is not allowed.
Error print scream:

[Marcio Novaes]

What do I do?

[Marcio Novaes]

I am waiting for some direction in order to write (edit) the table fields!

[Marcio Novaes]

The ibExpert does it!
So, it is not a firebird problem, as you stated in my first tick.
Or , maybe is better to remove the edit function in the field's descritions

[Marcio Novaes]

ticket , not tick. Sorry.

[Popa Adrian Marius]

Firebird 3 no longer allows direct updates to the system tables, as that was a way to potentially corrupt a database. See also System Tables are Now Read-only in the release notes. You will need to use DDL statements to do the modification. https://stackoverflow.com/questions/48267131/how-change-a-column-type-in-firebird3

[Marcio Novaes]

Popa, hi!
I found the new way to do this, in firebird 3,is using the command:
COMMENT ON <object> IS {'sometext' | NULL} <object> ::= DATABASE |
<basic-type> objectname | COLUMN relationname.fieldname | PARAMETER
procname.paramname <basic-type> ::= CHARACTER SET | COLLATION |
DOMAIN | EXCEPTION | EXTERNAL FUNCTION | FILTER | GENERATOR |
INDEX | PROCEDURE | ROLE | SEQUENCE | TABLE | TRIGGER | VIEW

So, it's a matter of changing the way FameRobin edit the comments. The
FameRobin is so practical that is a pity not have this feature.
THIA

Marcio Novaes Coelho

Em qui., 31 de out. de 2019 às 13:23, Popa Adrian Marius mapopa@users.sourceforge.net escreveu:

Firebird 3 no longer allows direct updates to the system tables, as that
was a way to potentially corrupt a database. See also System Tables are Now
Read-only in the release notes. You will need to use DDL statements to do
the modification.
https://stackoverflow.com/questions/48267131/how-change-a-column-type-in-firebird3

---

• [bugs:#295] https://sourceforge.net/p/flamerobin/bugs/295/ Can't save
  fiel description*

Status: open
Group: v0.9.4
Created: Thu Apr 18, 2019 02:38 PM UTC by Marcio Novaes
Last Updated: Thu Jun 13, 2019 06:36 PM UTC
Owner: nobody
Attachments:

• FlameRobin.png
  https://sourceforge.net/p/flamerobin/bugs/295/attachment/FlameRobin.png
  (152.9 kB; image/png)

I can't save the description field. Says that update on system tables is
not allowed.
Error print scream:

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/flamerobin/bugs/295/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

--
Márcio Novaes Coelho

</basic-type></basic-type></object></object>

[Popa Adrian Marius]

Fixed with : https://github.com/mariuz/flamerobin/pull/61/commits/5e8c175cbfb608129175f8f224c1101cc487485a