https://bugs.documentfoundation.org/show_bug.cgi?id=158452
Bug ID: 158452
Summary: FIREBIRD: Impossible to change field to "entry
required" in GUI after table has been saved
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 191132
--> https://bugs.documentfoundation.org/attachment.cgi?id=191132&action=edit
Open table "Tabelle1" for editing. Try to set "Name" to required → yes.
Open the attached database.
Open "Tabelle1" for editing, not for input data.
Change field "Name" in field Properties to → Entry required → 'yes'
Try to save the table.
An error appears:
The column "Name" could not be changed. Should the column instead be deleted
and the new format appended?
Now go to Tools → SQL.
ALTER TABLE "Tabelle1" ALTER COLUMN "Name" SET NOT NULL;
Status will show the useless message
1: at
/home/buildslave/source/libo-core/connectivity/source/drivers/firebird/StatementCommonBase.cxx:458
but the command will be submitted.
Go to View → Refresh Tables
and open "Tabelle1".
Field "Name" has set Entry required → 'yes'
It should be possible to set Entry required after a table has been edited and
saved. HSQLDB offers this possibility. The error, which appears in Firebird,
only shows: Changing isn't allowed by GUI.
Setting NOT NULL is the same code as required for HSQLDB.
Setting back to NULL requires
ALTER TABLE "Tabelle1" ALTER COLUMN "Name" DROP NOT NULL;
--
You are receiving this mail because:
You are the assignee for the bug.
