<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Form with subforms isnt working any more" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122408#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Form with subforms isnt working any more" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122408">bug 122408</a> from <a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> Robert Großkopf</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>