Created attachment 147919 [details]
Form that works
I have an existing Database with Forms that show the content in different Subforms.
The data where select by using >Sql queries< in the Subform and to filter them, i use the "verknüpfen" Form and Subform with more then 1 Field.
Until LibO 5.4.7 the Form works fine. After that, it stopt to work.
I put screenshots where you can take a look from what i mean.
Created attachment 147920 [details]
Form that dont work
Created attachment 147921 [details]
Could it be you are using Firebird? Then see bug 117589 and all the related bugs.
This Basefile was created with the embedded HSQLDB.
If i set the "verknüpfen von" only to the first Filterparameter <fi_id_tblm_Person> the Subform works.
But if i use only the second parameter <dt_KW_YEAR>, the SubFform contains again no data.
Could be, that the second "Table fields" don't match anymore?
I have to try to get an example Database.
Created attachment 147957 [details]
try the Forms to see the differnz.
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 220.127.116.11 - works only when changing the query. Then tested with LO 18.104.22.168 - 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.
Have tried it a little bit more. Queries, which connect a DECIMAL and YEAR("Date"), will work, but forms won't.
The I opened the forms for editing and set "Form Properties" > "Data" > "Analyze SQL command" > 'No' and the form will work.
So there must have been something changed in the process for analyzing an SQL-command. But this shouldn't happen. A connection, which works in a query (GUI and direct SQL) should also work in a form.
Tested with LO 22.214.171.124, OpenSUSE 15, 64bit rpm Linux.
I will set this bug to "New" and change the title for this bug a little bit.
Set the version to LO 126.96.36.199. This is the first installed version here where the bug appears:
CPU-Threads: 6; BS: Linux 4.12; UI-Render: Standard; VCL: gtk2;
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Doesn't appear with LO 188.8.131.52
You are right:
> CAST(YEAR( "dt_termindatum" ) AS DECIMAL(4,0)) "LaufJahr"
> will solve this problem in the code for the queries.
I think I have the same problem.
A form that has always worked (I think since LO 4), now crashes with LO 6.2.
See attachment 1 : form with LO up to 6.0
See attachment 2 :form with LO 6.2
Created attachment 149435 [details]
Created attachment 149436 [details]