Bug 109294 - table-edit-window: Modify order of the fields
Summary: table-edit-window: Modify order of the fields
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 122139 (view as bug list)
Depends on:
Blocks: Database-Tables
  Show dependency tree / graph
 
Reported: 2017-07-23 21:05 UTC by c.buhtz
Modified: 2023-04-05 15:09 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description c.buhtz 2017-07-23 21:05:55 UTC 
In my informations there is currently now comfortable non-SQL way to rearange the order of the fields presented in the table-edit-window.

I would suggest a simple up- and down-button in the toolbar for that.
Comment 1 Robert Großkopf 2017-07-24 05:51:54 UTC 
(In reply to c.buhtz from comment #0)
> In my informations there is currently now comfortable non-SQL way to
> rearange the order of the fields presented in the table-edit-window.
> 
> I would suggest a simple up- and down-button in the toolbar for that.

You are right, there isn't. The GUI has been created for many different database-engines. The internal database-engine HSQLDB only allows to set the position of  a new field by SQL, not to change the position of existing fields. Firebird would allow to position fields after adding them. So you could change the position at every time. Might be other database-engines won't allow to change the position at all.

Have set this one to "NEW", because there isn't any possibility to change the sorting order.
Have set the version to "Inherited from OOo", because it never worked in an other way.
Comment 2 Jorge Teixeira 2022-11-06 15:10:01 UTC 
*** Bug 122139 has been marked as a duplicate of this bug. ***