[Libreoffice-bugs] [Bug 133823] Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Oct 7 09:29:06 UTC 2020


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

debewerking at kpnplanet.nl changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |debewerking at kpnplanet.nl

--- Comment #3 from debewerking at kpnplanet.nl ---
Comment on attachment 161809
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161809
Test the two forms. Press the button: different column names will be shown with
the same SQL-code.

I experienced identical behaviour and like to strengthen Alex Thurgoods vision.
In a base query with SQL ( excerpt: CURRENT_DATE AS "datum", 'F' ||
"IDgbwriter" || "volgnr" AS "filenaam", ( "tblgb"."gb" - TRUNC( "tblgb"."gb", -
2 ) ) * 1000 + "volgnr" AS "factuurnummer") the aliases are correctly displayed
in the query GUI, however the same SQL string in a basic macro evaluated with
the PrepareStatement( stringSQL ) and executeQuery()shows that the given alias
names are ignored, and reassigned as "CURRENT_DATE" , ADD3 , CONCAT and the
like.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201007/706e601f/attachment.htm>


More information about the Libreoffice-bugs mailing list