Apache OpenOffice (AOO) Bugzilla – Issue 69428
Query Assistent mismach WindowsAdressBook query in special case
Last modified: 2009-07-20 14:55:20 UTC
1. A query of 'OE Contacts' created with the design mode makes problems, when the used databasefieldnames have a dot in it (german version). In the SQL-term of the query the part after the dot of the fieldname is missing. 2. The result of a query is empty. In issue 45673 was a similar bug concerning the wizard, which is fixed. With this fix this new bug was introduced. OOo 2.0.4 RC1 German
Hi, I can't reproduce this. If I create a query f.e. with the field "Telefon (gesch.)" I can execute the query whitout problems. Do you have any more information? Can you paste the sql string you use? Bye Marc
Hi, there two ways to select a datafield: 1: Double click in the window or drag & drop 2. Dropdown field If you use the second way the part after the dot is missing. I made a query using both ways to select a datafield. In the copied sql string the second and third datafields are selected using the first way. The other are selcted with the dropdown field. SELECT "Telefon (gesch", "Stadt (gesch.)", "Telefon (gesch.)", "Bundesland (gesch", "Telefon (gesch" FROM "OE Kontakte"
Hi jolatt, > If you use the second way OK , this one did the trick. set target to the next release and send to the right developer. bye Marc
set target
fs->oj: please take over
Fixed in cws dba24a
*** Issue 43433 has been marked as a duplicate of this issue. ***
targeting to 2.4, since the fix is part of a CWS aiming for this release
Please verify. Thanks.
fixed but failed -> now the part before the dot is cut (rather worst than before)
reopen issue
Please see also Ubuntu bug #131565, which indicates that this bug also affects database names: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/131565
I can not reproduce it. Could you please describe what you do different as to select a field from the list box in the grid control. thanks.
1. create a connection to an f.e. german (because of '.' in table field names) win-adressbook 2. open query design & add the table 3. choose the table from the 'grid listbox' 4. choose any field (containing a '.') from the grid listbox 5. push the run query button -> effect see attachement
oo overloaded -> send attachemant as mail
Fixed. The difference here is to select first the table name and then the column name.
verified in CWS dba24a find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba24a
This issue is closed automatically and wasn't rechecked in a current version of OOo. The fixed issue should be integrated in OOo since more than half a year. If you think this issue isn't fixed in a current version (OOo 3.1), please reopen it and change the field 'Target Milestone' accordingly. If you want to download a current version of OOo => http://download.openoffice.org/index.html If you want to know more about the handling of fixed/verified issues => http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues