[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=49145

--- Comment #17 from gmoll...@us.es ---
I believe that in this subject would enter:
And Base does not know how to use ENUM and SQL SET when connecting to MySQL.
Base should use a drop-down list to choose a value.
Mi kredas, ke en ĉi tiu temo eniros:
Kaj Bazo ne scias uzi ENUM nek SET kiam konektiĝas al MySQL. Bazo devus uzi
malsupren-liston por elekti valoron.
Creo que en este tema entraría:
Y Base no sabe usar ENUM y SET de SQL al conectar con MySQL. Base debería usar
una lista desplegable para elegir un valor.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=49145

mhonline  changed:

   What|Removed |Added

 CC||mh...@gmx.net

--- Comment #16 from mhonline  ---
to solve the weakness of linking records via listbox (catchword: horizontal
scrolling records to find selfexplaining keys) the requested enhancement would
really be helpful. So what is the status about this?

martin

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

--- Comment #15 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

Jochen d...@jochenschiffers.de changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #14 from Jochen d...@jochenschiffers.de 2012-08-23 18:37:25 UTC 
---
Status changed to NEW

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

--- Comment #9 from Alex Thurgood ipla...@yahoo.co.uk 2012-08-19 09:44:37 UTC 
---
(In reply to comment #6)


 In fact I wasn't thinking of the form-wizard. I was thinking of the plain
 grid-like table data editor: I was thinking of enhancing it to become an
 intelligent grid, containing listboxes in some columns, plain text boxes in
 other columns, ...and in the future perhaps also dropdown-calendar boxes for
 date fields.


Something like what is possible in MS Access or FMPro then ? 
In other words, having data aware controls in the table view or the grid
control. 

I know that this has already been requested in the past (I would need to look
up the bug number(s)), certainly at least for OOo, or on the previous OOo dba
mailing lists, and I seem to recall that Lionel Mamane, the main base dev of
the LO project had also considered that as one possible enhancement to the Base
feature set.

However, I would imagine that that would be no mean feat, as it would probably
require extending the current model-view-control paradigm. 

I'm not utterly convinced that this would be confusing for users, since other
db UI programs seem to do OK out of having such functionality, and it is
hypocritical of us to say that we would be blurring the lines between data
presentation/maniuplation via the form paradigm and simple data display via the
table paradigm, when a user can actually enter data directly into the table
anyway. If one were to be really strict about the separative approach, a user
would just be able to create a table by hand or with the wizard, and then BE
OBLIGED to create a form to enter data into it. At the moment, that simply
isn't the case, and certainly doesn't represent what happens in other
equivalent products. 

I would say that this is a valid RFE, but IMO it is a duplicate of one that is
already somewhere in the system or at least has been discussed on the dev list
(or IRC) previously.


Alex

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

--- Comment #10 from Jochen d...@jochenschiffers.de 2012-08-19 11:18:01 UTC 
---
@Rainer:
what should we do with this bugreport: WONTFIX or DUPLICATE (of what) or
...?

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

--- Comment #11 from Alex Thurgood ipla...@yahoo.co.uk 2012-08-19 12:36:46 
UTC ---
(In reply to comment #10)
 @Rainer:
 what should we do with this bugreport: WONTFIX or DUPLICATE (of what) or
 ...?

Jochen,

IMHO you can't say WONTFIX until a dev has had a chance to say something about
it, or until we can show that a decision has been made by the dev group to sort
it out or ignore it.

If you want to see whether it is a duplicate, search in bugzilla or the dev
mailing list (ESC minutes ??) for data aware control or something like that.

It is a recurring request, and has been since OOo days. The fact that nothing
has been done about it is irrelevant, other than an indication that to
implement the desired features requires more work than would appear on the
surface.


Alex

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

--- Comment #12 from Alex Thurgood ipla...@yahoo.co.uk 2012-08-19 12:45:46 
UTC ---
Reading this :

http://api.libreoffice.org/common/ref/com/sun/star/form/DataAwareControlModel.html

would seem to indicate that the API only supports data awareness via the
FormControlModel and the FormComponent service.

If that is really the case, then I would guess that implementing the requested
feature for Table View editing would require a new API or a modified API of the
MVC used for Table Views.

Alex

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

--- Comment #13 from Alex Thurgood ipla...@yahoo.co.uk 2012-08-19 12:58:53 
UTC ---
Also note that data aware controls in general for LO are being worked upon,
albeit for Calc for the time being :

http://lists.freedesktop.org/archives/libreoffice-commits/2011-December/024675.html

+// Need to flesh this out, currently we will only support data-aware
controls for calc
+// and only handle a subset of functionality e.g. linked-cell and cell
range data source. Of course later
+// we need to disambiguate for writer ( and others ? ) and also support
the generic form (db) bindings
+// we need some more work in xmlscript to be able to handle that


So, it is definitely do-able.


Alex

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

--- Comment #6 from fiod...@gmail.com 2012-08-17 07:09:37 UTC ---
(In reply to comment #5)
 @fioddor: I will change the title of this bug, so that everyone knows, that 
 it should be a feature of the form-wizard in base.

In fact I wasn't thinking of the form-wizard. I was thinking of the plain
grid-like table data editor: I was thinking of enhancing it to become an
intelligent grid, containing listboxes in some columns, plain text boxes in
other columns, ...and in the future perhaps also dropdown-calendar boxes for
date fields.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

--- Comment #7 from rob...@familiegrosskopf.de 2012-08-17 15:45:51 UTC ---
(In reply to comment #6)
 (In reply to comment #5)
  @fioddor: I will change the title of this bug, so that everyone knows, that 
  it should be a feature of the form-wizard in base.
 
 In fact I wasn't thinking of the form-wizard. I was thinking of the plain
 grid-like table data editor: I was thinking of enhancing it to become an
 intelligent grid, containing listboxes in some columns, plain text boxes in
 other columns, ...and in the future perhaps also dropdown-calendar boxes for
 date fields.

I don't know what you mean with plain grid-like table data editor. The only
way to link one table to another with listflieds is in a form. When you think
about a form there is no difference between a listfield in a tablecontrol or a
form itself.

When you think about input direct in the table in the table-view (not a form)
it will confuse everybody who creates tables. When there is a foreignkey, given
as numberfield INTEGER, I must see this number in the table, not the text,
which is connected to it. A form could hide it, not the table itself.

When you will use listfields or combofileds you have to choose a form.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

Jochen d...@jochenschiffers.de changed:

   What|Removed |Added

 Status|NEW |NEEDINFO
 CC||rainerbielefeldng@bielefeld
   ||undbuss.de

--- Comment #8 from Jochen d...@jochenschiffers.de 2012-08-17 15:56:29 UTC ---
Hi fioddor,

IMHO is your request neither a bug nor an enhancement but possibly a
misunderstanding how base in this detail works.
What is your opinion?

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49145] EDITING: Form-Wizard should propose listfields for foreign keys in a table

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49145

rob...@familiegrosskopf.de changed:

   What|Removed |Added

Summary|EDITING: LibreOffice Base   |EDITING: Form-Wizard should
   |should use dropdown list to |propose listfields for
   |input fields having a   |foreign keys in a table
   |foreign key |

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs