×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
"You have to CAST to fish...
CREATE VIEW BS AS select (
cast(T1.DKCWVA*POWER(10,-T2.AECJST as dec(5,2) ) as PoweredUp,
...
from...)"
This worked for me:
DECIMAL(SUM(T1.DKCWVA*POWER(10,-T2.AECJST)),11,2)
Thanks a lot Rob!
Peter Vidal
MAPICS IT Technical Support Team / SR System Analyst
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
Tel:727-849-9999, x2414 Fax:727-815-3120
http://www.pall.com
"If I take care of my character, my reputation will take care of itself."
Dwight L. Moody
--------------------------------------------------------------------------------
Attention:
This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all
copies of this communication.
--------------------------------------------------------------------------------
midrange.com
