[Libreoffice-bugs] [Bug 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 Lionel Elie Mamane changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |lio...@mamane.lu |desktop.org | -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #19 from Lionel Elie Mamane --- Debugging session notes: The problem seems to be that, when saving the form data, for the checkbox one gets into frm::FormOperations::impl_commitCurrentControl_throw (file forms/source/runtime/formoperations.cxx line 397) but neither xCurrentControl nor xCurrentControl->getModel() expose a XBoundComponent interface, so the commit is not done. (gdb) print xCurrentControl $25 = uno::Reference to (frm::OCheckBoxControl *) 0x32dd7f8 (gdb) print $26 = uno::Reference to (UnoControlCheckBoxModel *) 0x30eb7f8 However, weirdly *some* data is written out (not sure how...), but not referencevalue, but "true" or "false". OTOH, it seems that when *reading* the data it expects "0" or "1" to decide the state of the checkbox. -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 rob...@familiegrosskopf.de changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #18 from rob...@familiegrosskopf.de --- I set this bug to "New" - couldn't confirm it with Postgres as a special database, but with the internal database, when the field isn't a bool-field but a char-field. -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #17 from rob...@familiegrosskopf.de --- (In reply to comment #1) > I changed the column width to 30 characters - and discovered that the values > "true" and "false" are written to the database. > > This means that LO is simply ignoring the values for the reference values ON > and OFF that are entered in the check box definition on the form. The reference-values are completely ignored by every version of LO and OOo. You could write inside what you want. It is set to '1' (true) and '0' (false). This hasn't been changed since LO 3.6 ... -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #16 from rob...@familiegrosskopf.de --- Created attachment 86305 --> https://bugs.freedesktop.org/attachment.cgi?id=86305&action=edit Open the form, try to change "Char5" to "true" - doesn't show the change Hope, that the attachment shows the same bug as reported for the connection to PostgreSQL. LO since 4.1.0.0 beta1 When I open the form and try to change the value for the checkbox of the char-field the value in the table is changed to 'true' (not '1'). This value is not shown in the checkbox, when I open the form again. Up to LO 4.0.5.2 When I change the value for the checkbox of the char-field, it is changed to '1' or '0', not to 'true' or 'false'. This value is shown in the checkbox. But if there are values like 'true' and 'false', this values are also shown ... Is this the same bug? Then let us set it to new and change the title. -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #15 from Alex Thurgood --- I have also seen a similar report on the French users' list. Alex -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #14 from Alex Thurgood --- @ALL A user has reported a similar problem using mysql and LO checkboxes linked to boolean fields on the English user list - the two problems might be related. Alex -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #13 from rob...@familiegrosskopf.de --- (In reply to comment #12) > My LO is from here: > > deb http://ppa.launchpad.net/libreoffice/libreoffice-4-1/ubuntu precise main So you don't use the LO-version directly from LO. There are many differences between the connection to external databases with the original versions and the versions, which are specially created for one Linux-system. Remember, that I could only start the connection to PostgreSQL through ODBC with the LO-version of my System (OpenSUSE) - not with the original rpm-packages from LO. And only with this version I can't reproduce what you are writing. I can create a boolean field with the direct connection and it is shown with ODBC as field fix 1 char. Did you report this bug also to Ubuntu - the packages are from Ubuntu ... -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #12 from Jan Rheinländer --- My LO is from here: deb http://ppa.launchpad.net/libreoffice/libreoffice-4-1/ubuntu precise main -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #11 from Jan Rheinländer --- I created the boolean field in pgadmin3 and it doesn't give me the option to enter any field length. No idea why it would turn up as length 5 in base. If I create a "Yes/No (char)" field in Base, it comes out as character length 1 in pgadmin. If I use the "Yes/No" field created in base for my form, I have the same problems as before (value to long for field). So creating a "real" boolean column in pgadmin seems to be the only working solution. -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #10 from rob...@familiegrosskopf.de --- (In reply to comment #9) > > The two columns (old that doesn't work, new that does) show up as following: > pgadmin: > old: character length 1 > new: boolean > > base: > old: text (fix) [char] Length 1 > new: text [varchar] length 5 > > and the value stored in the boolean column shows up as 0 and 1 in Base. I have created a boolean field with the direct connection. It has been shown in ODBC-connection as text (fix) [char] Length 1. So it has been shown as your old version in base. Why should a boolean filed have a length of 5? For "false" and "true"? So let's have a look at the difference between our systems. You aren't using the same system as I. Where does the LO-version come from: Linux-repository or directly from LO (which doesn't work here ...)? -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #9 from Jan Rheinländer --- (In reply to comment #8) > What type of field have you set for this checkbox before? Where have you > created the field? In MySQL directly, with Base and ODBC ... I think I created it in Base, but I am not sure, it might also have been pgadmin. Its about 2 years since. The two columns (old that doesn't work, new that does) show up as following: pgadmin: old: character length 1 new: boolean base: old: text (fix) [char] Length 1 new: text [varchar] length 5 and the value stored in the boolean column shows up as 0 and 1 in Base. -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #8 from rob...@familiegrosskopf.de --- (In reply to comment #7) > Thanks for the hint - changing my database column into a boolean data type > turns out to be a useable workaround. So I can at least move to LO 4.1 now. > When I have read "checkbox" I thought it must be a boolean field. But my ODBC-connection doesn't show it as boolean - only char(fix) for 1 character. > But of course this doesn't resolve the bug itself because the values for the > reference values ON and OFF that are entered in the check box definition on > the form are still being ignored by LO 4.1 . What type of field have you set for this checkbox before? Where have you created the field? In MySQL directly, with Base and ODBC ... -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #7 from Jan Rheinländer --- Thanks for the hint - changing my database column into a boolean data type turns out to be a useable workaround. So I can at least move to LO 4.1 now. But of course this doesn't resolve the bug itself because the values for the reference values ON and OFF that are entered in the check box definition on the form are still being ignored by LO 4.1 . -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #6 from rob...@familiegrosskopf.de --- Now I have tested a little bit more. I don't use external databases - only test them. I set in the advanced settings for the database "Respect the result set type from the database driver". With this settings I could input data into PostgreSQL with ODBC - LO 4.1.1.2. I could also write into boolean-fields (which are shown as char-fix). I could also input data into this field with a check-box in a form. All this works with OpenSUSE 64bit rpm and the version of LO, which I could download from OpenSUSE. The connection to PostgreSQL with ODBC doesn't work with any other version of LO I have installed. All versions LO 4.* would crash, when I try to open the table, not when connecting to PostgreSQL. I could see the tables, but not the content. -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #5 from Jan Rheinländer --- Changing to direct connection means that I have to edit all queries, forms and reports because the "url" schema for tables changes, e.g. cdp.public.villages becomes just public.villages That's a huge amount of work! Apart from that, the reason I chose ODBC is that when I set up the database, it was a lot stabler than direct connection. Or to put it less polite, direct connection was totally unusable :-( So I am wary of going to direct connection because I don't know what new bugs will bite me. And its a production database so I can't experiment too much! -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #4 from rob...@familiegrosskopf.de --- I have tried to reproduce this, but I can't start PostgreSQL with ODBC and any LO 3.*-Version. I have tested with the direct connection and LO 4.1.1.2. There the table shows a field with fieldtype "bool" - the right type and also the right checkboxes in the table and in the form. Same LO-version, ODBC, same table. The field is shown as "fix char", all with 1 and 0 inside. When I will create a form for this table the field is a text-field. Changing this field brings the dialog "the target rows is out of the rowset". But I get the same message, when I try to change data in other tables. I can't test with other versions of LO - see above. Could be my ODBC-configuration is wrong ... So I can't confirm this bug. I would prefer to change from ODBC to the direct connection ... -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 Jan Rheinländer changed: What|Removed |Added Severity|critical|blocker --- Comment #3 from Jan Rheinländer --- This bug is preventing me switching to LO 4.1 from LO 3.6 -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 Jan Rheinländer changed: What|Removed |Added Severity|major |critical -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 --- Comment #2 from Jan Rheinländer --- But even if I change my reference values to "true" and "false" (or leave the fields empty) and change my database to replace all the 0 and 1 by true and false it doesn't work. true and false are written to the database from the form but when reading from the database into the form only 0 and 1 are interpreted, everything else is interpreted as "false" and leaves the tick box empty. I changed the status to critical because de facto tick boxes simply don't work and there is no work-around -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 Jan Rheinländer changed: What|Removed |Added Priority|medium |high --- Comment #1 from Jan Rheinländer --- I changed the column width to 30 characters - and discovered that the values "true" and "false" are written to the database. This means that LO is simply ignoring the values for the reference values ON and OFF that are entered in the check box definition on the form. -- 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 68657] EDITING: Postgres/ODBC - Check box in database form does not work any more
https://bugs.freedesktop.org/show_bug.cgi?id=68657 rob...@familiegrosskopf.de changed: What|Removed |Added CC||rob...@familiegrosskopf.de Summary|EDITING: Check box in |EDITING: Postgres/ODBC - |database form does not work |Check box in database form |any more|does not work any more -- 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