« Return to Thread: 11.1 -> 11.2 upgrade problems

Re: 11.1 -> 11.2 upgrade problems

by Yogi Jivanandanatha :: Rate this Message:

Reply to Author | View in Thread

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.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
**********************************************************************

 « Return to Thread: 11.1 -> 11.2 upgrade problems

LightInTheBox - Buy quality products at wholesale price!