If you have a list view with unstored calculations, they often don’t display or refresh properly.
This used to work fine under RC3 but is a real problem now.
Also, I the suggested method for looping through these records and updating the unstored calcs does not work consistently or reliably.
Any ideas???
do you have an example where you see unstored calculations not refreshing?
In RC7 if you have a field on a list view (in this case in a tabpanel) and the displayTags property is set to true then it will not display properly/reliably. This is certainly the case when the field is from a related table and also has a toolTipText applied.
In RC3 this was not a problem.
The solution is to turn off the displayTags property for fields.
One question - what possible use is this for fields - surely this property is only of use for labels?
Since removing the displayTags property, the toolTipText does not display.
Is this a bug?
Also I am having problems in RC7 refreshing unstored calcs.
I have a tasks table with both a start_date and and end_date as stored fields. I have an unstored calc text field which returns a simple html timeline where the task duration is graphically displayed as a label on a list view form. The scale is set via a global field - so each user can set the scale independenlty and can go fwd and back a week. Under RC3 this used to work fine and I had a refresh method called whenever the form is displayed or the scale is changed.
Under RC7 the refesh method does not work. I have tried setting the displayTags property of the label both on and off with the same results. If I double click 4 or 5 times on the label on each line then it eventually refreshes, but I cannot get the refresh to work via a method.
Here is the method I am using to refresh…
for (var i=1; i<= controller.getMaxRecordIndex(); i++)
{
controller.recordIndex = i;
elements.timeline_bar;
}
controller.sort(‘task_lines_to_tasks.start_date asc’);
application.updateUI();
Any ideas?
Since removing the displayTags property, the toolTipText does not display.
Is this a bug?
Also I am having problems in RC7 refreshing unstored calcs.
I have a tasks table with both a start_date and and end_date as stored fields. I have an unstored calc text field which returns a simple html timeline where the task duration is graphically displayed as a label on a list view form. The scale is set via a global field - so each user can set the scale independenlty and can go fwd and back a week. Under RC3 this used to work fine and I had a refresh method called whenever the form is displayed or the scale is changed.
Under RC7 the refesh method does not work. I have tried setting the displayTags property of the label both on and off with the same results. If I double click 4 or 5 times on the label on each line then it eventually refreshes, but I cannot get the refresh to work via a method.
Here is the method I am using to refresh…
for (var i=1; i<= controller.getMaxRecordIndex(); i++)
{
controller.recordIndex = i;
elements.timeline_bar;
}
controller.sort(‘task_lines_to_tasks.start_date asc’);
application.updateUI();
Any ideas?
In RC7 if you have a field on a list view (in this case in a tabpanel) and the displayTags property is set to true then it will not display properly/reliably. This is certainly the case when the field is from a related table and also has a toolTipText applied
What is not displayed properly? The tooltip or the data itself? And on what kind of field? Just a textfield?
We made somefixes for this for datafields.
I now have a textfield that has displayProperty set as true.
the thing i show in that fields is a related field (orders_to_orderddetail.quantity) and the tooltip i show there is a value of the parent record.
One question - what possible use is this for fields - surely this property is only of use for labels?
no can be used for fields also. But that wasn’t used very much because there was never a need for that. But now if you want to display tags in a tooltip you have to set/use it.
Since removing the displayTags property, the toolTipText does not display.
the tooltip should display.. (but then the %%TAG%% )
again what kind of field are you using??
Can you send me an example with that refresh problem?
(and with that a problem description why you exactly want to trigger that unstored calc)
Here is an attached solution file.
You should see the problems with fields not refreshing etc in the task_lines file.
This occurs in the task_name (the values seem to flick on and off when you mouse over) and timeline fields (you have to repeatedly click on the field to get the display to work).
Please let me know about this asap - it is causing a real problem.
Thanks
Chris
I don’t quite understand what you are saying that goes wrong.
The only thing i see that is going wrong is that when i click on new line in the main form . I have to click it twice to see the first one added (and if fill in the first one the second one appears)
That i will try to fix asap.
I am getting the following errors…
First I create 2 tasks, and for each I add 3 or 4 lines by clicking on the New Line button. When I click on the Show Lines button on either task, the relevant lines show in the bottom pannel. So far so good, although there is the refresh problem you noticed.
However there are 2 real problems (see attached screen grab)…
The task name field in the bottom pannel only shows on some rows and seems to appear/disappear randomly when I click on any row. This stops happening when I turn off the displayTags property, but then I can’t get any alt tags (i.e. toolTipText) to work.
The html label (showing a timeline based on an unstored calc) does not refresh when I change the global_start_time field. However, when I double click repeatedly on the field on each line, then eventually it does refresh.
I am running the following environment for my server…
Server Information
Servoy version R2 2.0 rc7-build 266, repository version 20
Uptime: 1 day 18 hours 16 minutes 21 seconds
JDK Information
java.vm.name=Java HotSpot™ Client VM
java.vm.version=1.4.2_03-b02
java.vm.info=mixed mode
java.vm.vendor=Sun Microsystems Inc.
Operating System Information
os.name=Windows 2000
os.version=5.0
os.arch=x86
I am running Macs and PCs as clients - but mostly PCs running Win XP SP1 and Java 1.4.2_03-b02. I am getting the problem both in Servoy developer and client.
What is really strange is that this all worked fine under RC3 - although there were lots of other problems with RC3 which is why I needed to upgrade to RC7.
The file I have sent you is a test file showing these problems. My live solution has 30 users ‘relying on it’ and I am now also getting other problems with aggregated fields not adding up properly. For example if I have an invoice with a line_total field and then an aggregate field called sum_line_total, then this sum is not always adding up properly. You can imagine this is a bit of a problem when sending clients invoices which do not add up. I suspect this is related and will try and get you an example of this as well.
Please get back to me ASAP.
Ta
Chris
We changed already quite a lot for those tooltips handling so in the current build the task name always is displaying nicely.
calculations not refreshen on global change, is a problem
For not the only solution is to attach a method on datachange of that global field and then refresh the calculation youreself.
Yoy can do that by setting it nu null:
for(var i=1;i<=main_to_task_lines.getMaxRecordIndex();i++)
{
main_to_task_lines.recordIndex = i;
main_to_task_lines.timeline = null;
}
the problem is that in the current build (RC7) this also doesn’t have anyeffect. because you couldn’t set calculations.. I changed that now.
Not sure I understand you.
Are you saying that you are getting both these problems as well in RC7 and that there is a new release out soon?
If so, when?
I am rather desperate now.
My live solution has 30 users ‘relying on it’
And you are using a RC version?
I think the warning, above the Latest Release are clear:
NOTE: this is a Release Candidate, use with caution and make BACKUPS before you start.
I know the guys from Servoy are doing an tremendous job in speed of answering and bugfixing, but still, I should NOT use a RC-version in production!
Unfortuately there were several bugs in the previous non beta release which were fixed in RC3.
I was thus forced to (and advised by Seroy) to use RC3 in production.
Mostly this was OK, but there were some more bugs fixed in RC7 and I needed these fixes.
I am now in a situation where there is no version which I can use in production.
refresh problems of calculations/aggregations are fixed in 2.0RC8
Many thanks
Chris