One of my parent tables has a reference total field set up as Numeric(10,2). I calculate some child records (child.qty * child.price * child.markup), then compare that to the current value stored in the parent header.
So the SQL select on the child records returns a sum like 254.0321, but when I use Cast() on the result, it will not test out as equal to 254.03 which is the value stored in the parent table. llAuditPassed=Cast(csrAudit.nTestTotal as Numeric(10,2))=Parent.RefTotal (will return .F., but should be .T.) If I use Round(csrAudit.nTestTotal,2) it does test as .t. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00ba01c97bdc$84b07c30$8e1174...@com ** 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.
