Problem with SELECT statment
Hello,
I have a problem with SQL SELECT ... statment.
We're running 4GL 4.10 with OnLine 5.0 on HP G30 machine
running HP-UX 9.00.
---------------------------------------------------------
Table name : table_x
---------------------------------------------------------
field_1 decimal(8,2)
field_2 decimal(8,2)
....
field_n decimal(8,2)
---------------------------------------------------------
View name : view_v
---------------------------------------------------------
CREATE VIEW view_v ( field_1v, field_2v,.., )
AS SELECT field_1+field_2, field_3,..
FROM table_x
---------------------------------------------------------
SELECT sum( field_1v+field_2v+field_3v+...)
INTO sum1
FROM view_v
SELECT sum( field_1v*100+field_2v*100+field_3v*100+...)/100
INTO sum2
FROM view_v
sum1<>sum2 !!! ( ex. 423597 <> 423613.65 )
===========================================================
Can someone help me?
Jacek Brzozowski
Internet: jacek@termit.art.olsztyn.pl