Bug 122139 - LO Base: add a possibility to move tables' fields up and down (UI improvement)
Summary: LO Base: add a possibility to move tables' fields up and down (UI improvement)
Status: RESOLVED DUPLICATE of bug 109294
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.0.0.alpha0+
Hardware: All Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Base-UX Database-Tables
  Show dependency tree / graph
 
Reported: 2018-12-16 15:34 UTC by Vera Blagoveschenskaya
Modified: 2022-11-06 15:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
scr (35.00 KB, image/png)
2018-12-16 15:35 UTC, Vera Blagoveschenskaya 		Details
View All 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 Vera Blagoveschenskaya 2018-12-16 15:34:46 UTC 
Description:
LO Base: add a possibility to move tables' fields up and down (UI improvement)

Steps to Reproduce:
This is a suggestion to improve UI for LO Base

1. Create a new database (HSQLDB Embedded)
2. Create new table
3. Forgot to create Primary key, and create it while saving the table
4. Want to add new field in the table

Actual Results:
There is no possibility to move up or down for some field.
For example, I want my Primary Key to be at the top of the list, but I can't move it up..

Expected Results:
Add some possibility to move tables' fields up and down


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.0.0.alpha0+
Build ID: e3e15d8c625cbf56e1f03d9ebde966e78844c7a4
CPU threads: 1; OS: Linux 4.14; UI render: default; VCL: kde5; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-12-13_20:10:25
Locale: ru-RU (ru_RU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Vera Blagoveschenskaya 2018-12-16 15:35:02 UTC 
Created attachment 147605 [details]
scr
Comment 2 Robert Großkopf 2018-12-16 16:31:02 UTC 
It isn't possible to move fields by the GUI. So I will set this bug to new.

Note: HSQLDB only offers to move a new field at a special position by

ALTER TABLE "address" ADD "forename" VARCHAR(25) BEFORE "name";

Firebird offers

ALTER TABLE "address" ALTER "forename" POSITION 2;

So you could position the fields in Firebird after you have created the whole table through the GUI.
Comment 3 Jorge Teixeira 2022-11-06 15:10:01 UTC 

*** This bug has been marked as a duplicate of bug 109294 ***