Aloha John,
We just upgraded from 2004.7 to v11.2 server. Lots of issues we are
working out. One is the Sum function. For us, it works properly when
the field is indexed, and returns bogus values when the field is not
indexed. Are you using sum on an un-indexed field? I'm going to chat
with tech support about this and see what they can do. Seems like a bug.
Interesting about the current record not being summed. In my example I
thought it was only negative numbers that were being summed (on a
field with no index), but it could have been the current record that
was excluded.
Yogi Jivanandanatha
On Jul 1, 2008, at 6:46 PM, John DeSoi wrote:
> I have a pretty simple application I upgraded to 11.2 where I have
> noticed a number of problems I was not having with 11.1.
>
> To start, 11.2 did not recognize any of my previous preferences. I
> had to reset method colors and just about every setting in
> preferences.
>
> My runtime volume build with no changes other than the 11.2 upgrade
> no longer knows about all the words I saved in the dictionary during
> spell checking.
>
> A procedure that worked in 11.1 now sometimes reports that a record
> is locked, but if you check LOCKED ATTRIBUTES in the same method all
> the values are empty.
>
> The worst problem is that the Sum function returns an incorrect
> value when called from a form method or object script. It finally
> dawned on me it was summing all the selected record values except
> for the current record. Here are two traces of the same code, one
> called from a form method and the other called from a method run in
> a new process:
>
>
>
>
>
>
> Here the current record value amount is 50, but Sum returns zero.
>
>
>
>
>
>
> 4D reports both the structure and data are OK.
>
>
> Anyone else having these problems, or just me?
>
>
> John DeSoi, Ph.D.
>
>
>
>
> **********************************************************************
> 4D Server v11 SQL has arrived!
> Buy it NOW at
http://store.4ddepot.com>
> 4th Dimension Internet Users Group (4D iNUG)
> FAQ:
http://www.4d.com/support/faqnug.html> Archive:
http://dir.gmane.org/gmane.comp.lang.inug-4d.tech> Unsub: mailto:
4D_Tech-Unsubscribe@...
> Post: mailto:
4d_tech@...
> Options:
https://lists.4d.com/mailman/listinfo/4d_tech> **********************************************************************
**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at
http://store.4ddepot.com4th Dimension Internet Users Group (4D iNUG)
FAQ:
http://www.4d.com/support/faqnug.htmlArchive:
http://dir.gmane.org/gmane.comp.lang.inug-4d.techUnsub: mailto:
4D_Tech-Unsubscribe@...
Post: mailto:
4d_tech@...
Options:
https://lists.4d.com/mailman/listinfo/4d_tech**********************************************************************