General information
Category:
Coding, syntax & commands
>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.
For determining the length of a column, a sql statement is executed twice for the first record, so if record say returns 1. the length will be set to 1.
you can try something like mycolumn+000000.00
Previous
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