<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Report editor Add Fields bug when Report is based on select all query from an Alias field" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113884#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Report editor Add Fields bug when Report is based on select all query from an Alias field" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113884">bug 113884</a> from <a class="email" href="mailto:BridgeportContractor@gmail.com" title="Howard Johnson <BridgeportContractor@gmail.com>"> Howard Johnson</a> <pre>:-) I love bugs. So I tested again and could NOT make it fail this time (LO v5.3.3.2/Debian linux 9.2 x64/Cinnamon 3.2.7), ... but not giving up I also installed v5.4 and re-tested, same result: could not make it fail, (and same on v5.2). ......Then I tinkered w/ it some more: Edited Query_Table1 and re-named the Alias to Txt-Alias2, then Edit 'A Report', and now it fails. After tinker a bit more the bug is still there. Here is a full procedure of steps to re-produce it from scratch on 5.4. If you can confirm this, I'll submit this as a brand new, clean verifiable bug report and we can close this one. The following procedure shows this in Editing Forms, so it is in both Forms and Reports. It does seem to involve the order in which things are done. --- In short ------------------------------------ 0) Open LO 5.4 1) Create a new database 2) Create a table 3) Create 2 queries, the 2nd one based on the first one 4) Create a new form 5) Edit 2nd query to add an Alias name 6) Edit Form 1 again; change Content to Query2; Add Field -> bug --- In detail ----------------------------------- 0) Open LO Base 5.4 1) Create a new database: HSQLDB; Finish; Name it 'Query bug' 2) Create table in design view Field name ID, Int, Primary key, Autovalue Yes Field name Txt, Text [Varchar] Close and save as 'Table1' 3a) Create a query in design view Tables: Table1; Add; Close Double click ID Double click Txt Close; Save as Query1; Ok 3b) Create query in design view Queries, Query1; Add; Close Double click: * Close; Save as Query2; Ok 4) Create form in design view Form navigator Right click on Forms; New: Form Right click on Form; Properties Content type: Query Content: Query 1 Add field Shows ID, Txt Close form and save as Form1 5) Edit Query1 Enter 'Txt-Alias' for Txt Alias Close; Save the changes 6) Edit Form1 Right click on Form; Properties Change Content to Query2 Click Add Field Shows: ID, Txt BUG: Expected it to show: ID, Txt-Alias. ----------------------- Thanks Robert.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>