[Libreoffice-bugs] [Bug 122408] Form with subforms isnt working any more

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Robert Großkopf <robert at familiegrosskopf.de> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190103/f4f74d2d/attachment-0001.html>