--- > > >I know you can think i'm just silly, but ... >assuming that there is a minus operator within calculation, >it is possible to reach a zero result ; >so, what is the result if you : >select sum (ncost - lnFreight) * nshipqty from msambb where cclass = "CLASS" >? > > >G?rard. Hi Gerard,
I check the variables just before and insert command the they each have the correct numeric value. It's very weird indeed. I have a few statements that make some calculation and add the results to that table. The others work... Jose. José Olavo Cerávolo http://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
