Hi All
I have a problem that have been bugging me for ages, I don't know if any of you ever had the same problem, but some of my friends did....
I'm using OE 10.1B and webspeed.
My problem begins when I'm building reports using webspeed. Just a simple report to display my table's contents.
e.g.
the problem is sometimes when I change field_value, my report still display it's previous value. It's like webspeed is buffering my table's value. And FYI it's this syndrom happens on few updated records. Not all records. so in my reports some values updated, and some other still the same. But the next time I refresh my report it displayed all updated values.
My friend told me to use EXCLUSIVE-LOCK instead of NO-LOCK to force webspeed to always check fields value properly. At some poit my friend was correct for my reports always display my records' latest value. But I don't think that using EXCLUSIVE-LOCK is a proper solution for this.
PS. restarting webspeed broker makes this problem dissapear for some time, but it will appear again after a period of time until the broker rebooted again.
Any help appreciated.
my best regards
YoChan
I have a problem that have been bugging me for ages, I don't know if any of you ever had the same problem, but some of my friends did....
I'm using OE 10.1B and webspeed.
My problem begins when I'm building reports using webspeed. Just a simple report to display my table's contents.
e.g.
Code:
.....
<%
FOR EACH table_x NO-LOCK.
%>
<tr>
<td>`table_x.field_name`</td>
<td>`table_x.field_value`</td>
</tr>
<%
END.
%>
....
the problem is sometimes when I change field_value, my report still display it's previous value. It's like webspeed is buffering my table's value. And FYI it's this syndrom happens on few updated records. Not all records. so in my reports some values updated, and some other still the same. But the next time I refresh my report it displayed all updated values.
My friend told me to use EXCLUSIVE-LOCK instead of NO-LOCK to force webspeed to always check fields value properly. At some poit my friend was correct for my reports always display my records' latest value. But I don't think that using EXCLUSIVE-LOCK is a proper solution for this.
PS. restarting webspeed broker makes this problem dissapear for some time, but it will appear again after a period of time until the broker rebooted again.
Any help appreciated.
my best regards
YoChan