[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