Hi Yogi,
On Jul 6, 2008, at 3:22 PM, Yogi Jivanandanatha wrote:
> 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.
>
Yes, I was using an unindexed real field. If I index it it, I get the
correct value.
> 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.
I did some further investigating and here is what I found. I was only
seeing this error in my form or object methods. The form was being
opened from a generic listbox project form which lists records for all
my tables (uses fields, not arrays). If I open the form in a separate
process, Sum gives the correct value. So that led me back to the
process displaying the fields with the list box. If I put the code in
a menu item procedure called from that process, Sum gives the wrong
value.
John DeSoi, Ph.D.
**********************************************************************
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**********************************************************************
