https://bugs.documentfoundation.org/show_bug.cgi?id=133823
debewerk...@kpnplanet.nl changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |debewerk...@kpnplanet.nl
--- Comment #3 from debewerk...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
