Replace the last two 0's with some figure and the check the table to see what you have. JERRY
-----Original Message----- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Wednesday, February 13, 2013 9:50 AM To: ProFox Email List Subject: RE: VFP5 question about SUM - Crazy behaviour Have you got a relationship between the cursor/table you are summing and the Msambb table at all? Dave C -----Original Message----- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of José Olavo Cerávolo Sent: 13 February 2013 14:39 To: profox@leafe.com Subject: VFP5 question about SUM - Crazy behaviour Hi All, I am maintaining a software written in VFP 5.0a. Here's some code I wrote for a new function. sum (ncost - lnFreight) * nshipqty for cclass = "CLASS" to lnBox lnBoxDisc = lnBox * 0.03 insert into Msambb values ("CLASS", "", "SELECTED CLASS", 0, 0, 3, 0, 0, lnBox, lnBoxDisc) Now, after the sum, if I check on the variables, they both have a numeric value. But the record added in the table displays 0.00 in the 2 last fields. No errors were raised. I use SUM in a couple of other places in the same method updating the same table and it works. Is this another issue with VFP5 or I am just not seeing the issue? Thanks, Jose. José Olavo Cerávolo http://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5FA9D5CB171D4797974DE7A32A8B5922@jerryfootePC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.