https://bugs.documentfoundation.org/show_bug.cgi?id=122408
--- Comment #6 from Robert Großkopf <[email protected]> ---
You have tried to connect a DECIMAL to an INTEGER.
You have set "dt_KW_YEAR" as DECIMAL(4,0). DECIMAL is used for values with
decimal places, like "Betrag [€]" DECIMAL(8,2).
If you get YEAR("dt_termindatum") it will be an INTEGER or SMALLINTEGER.
CAST(YEAR( "dt_termindatum" ) AS DECIMAL(4,0)) "LaufJahr"
will solve this problem in the code for the queries.
Don't know why LO 5.* could connect this, but there are some problems with data
types discussed (and partly solved) for Firebird.
Have tested it with LO 6.1.4.2 - works only when changing the query. Then
tested with LO 5.4.6.2 - works also when connecting data types that do not
match.
By the way: I'm using "Turtle Sport" for trainings-data. Works nice with all
data my heart rate monitor could export.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
