When showing a related form via a tab-panel, if that form contains a calulated field it will only show blank/no records in List & Table views.
What seems to happen is that it renders/paints it containing the related records, and then wipes it.
If you remove the calculated field from the form, it works again.
I’ve replicated this in a new solution to be sure, but this is happening in 2.2.3.
Lee.
UPDATE:
This bug is NOT present in 2.2.2 (build 334).
This bug IS present in 2.2.3 (build 335).
Platform:
Windows XP SP2
Java 1.5.0_04-b05
Lee.
I am working with 2.2.3, and use calculations in related tabpanels all over the place, but I do not see this problem!!
I’ve made a fresh install sans plugsin/beans to make sure that this is a bug. I am able to reproduce this problem consistantly.
This bug was NOT reproducable when using the CRM database using the Sybase JDBC driver. This bug WAS reproducable using different databases using JTDS (SQLServer) and MySQL JDBC Drivers.
The following is a simple form with a tabpanel relation WITHOUT a claculated field which is obviously working:
This is the same solution, with the ONLY difference being that a calc field has been added to the form within the tabpanel:
Finally, the link below is a captivate movie capture that illustrates the bug.
http://click4tr.u23.shouri.net/servoyBug/servoy_bug_capture.htm
Cheers,
Lee.
Hi Lee,
Hope that you are well, chum !
Does the calculated field display in original form that you have placed in the tab panel - That is, does the problem stem from the original form or from showing it inside the tab panel ?
Cheers
Harry
Hi Harry!
Nope the problem only occurs when the form is within a tabpanel. Also when I went back to 2.2.2 the problem disapeared.
If you look realllllllly closely you can see the correct records being painted in the tabpanel, and then blanked 10ms or so later.
The odd thing was that I couldn’t make this happen with the CRM database that is in Sybase. But this is definatly not working when the database is either SQLServer or MySQL (not tried postgres yet).
All very odd. I’ve gone back to 2.2.2 for the mean time.
Lee.
what kind of error do you see in youre log?
I can’t reproduce it when using postgresql
I can’t believe that is the database that is causing this because if this was the case you have to see some database errors in the log.
What is that calculation that you use?
Do you have a test solution for me that uses mysql als its data?
There are no errors showing in console at all.
I just noticed something else odd. The bug did not appear when the solution was opened. Only once you’d gone into designer mode and back the bug reappears as per the SWF movie.
Additionally, it is with any calculation. The example SWF is using a calculation returning TEXT with “return 1;” as the calculation.
I’ve just sucsessfully reproduced the bug using Postgres 8.1 as a datasource.
I’ll send the solution including data that is at issue to the support email address.
Lee.
Bump…
Can anyone @ Servoy confirm that this is a bug?
Lee.
leemcneil:
Bump…Can anyone @ Servoy confirm that this is a bug?
Lee.
Looking at the status of this in our system: support is still waiting for a test solution from you. Send it to support@
i just imported youre solution in my 2.2.3 using mysql as the repository and data server.
And i don’t see any problem as far as i can see. All the data is showing fine.