Can you post some sample data here and your code?
Preferably post the sample data using CREATE and INSERT statements so we
can copy and paste the code into a program to test it out.
Frank.
Frank Cazabon
On 14/02/2013 04:52 PM, José Olavo Cerávolo wrote:
---
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
---
[excessive quoting removed by server]
_______________________________________________
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.
