General information
Category:
Coding, syntax & commands
Title:
How to typecase a numeric type
I am using FPW26. I am trying to UNION two select statement. The SELECT statement looks like the following:
SELECT a.doc_no, doc_date, SUM(apply+discount+miscellaneous) AS problem;
from a, b ;
where a,doc=b.doc ;
UNION ;
SELECT a.doc, doc_date, doc_amt ;
from a ;
where .......
Anybody can tell me how I can force the SUM() type to be the Numeric size I want. apply is N(9,2). discount is N(7,2), miscellaneous is N(7,2), problem ended up as N(16,2) and my doc_amt is N(9,2). How to force problem to be N(9,2)?
Tai SC
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only