General information
Category:
Coding, syntax & commands
Title:
SELECT SQL Problem?
Hi all,
When I do a SELECT SQL, can I use a function to do calculation and return to a cursor? Example: SELECT cnoee, dmysum(yamt1+yamt2+...) from dpayrslt. If yes, how does the SQL knows what type and how many decimal it should create for the second field?
Actually I have done the above and the second field it returns currency which I wants. When I change the SQL to SELECT dpayrslt.cnoee,demas.cname,dmysum(yamt1+yamt2+....) from demas,dpayrslt where demas.cnoee=dpayrslt.cnoee, the second field becomes numeric 1? Why and how I overcome this?
Thanks in advance.
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