Unknown Rounding Problem...

scott wagler stonecold99@hotmail.com
Fri, 24 Jan 2003 10:07:13 -0500


Hello Everyone,

Using Quiz 8.13.D1 on SunOS 5.7 (oracle database)

I am querying a couple numeric (integer signed) fields into a cursor, and am 
noticing that the values are being automatically rounded.

(ie. 0.04759 is being returned as 0.048)

The query is returned to a text file, and this rounding only occurs when the 
fields returned exceed the page width.  The query then continues onto the 
next line of the file.  If the query doesn't exceed the page width, the 
fields are not rounded.

unfortunately, the number of fields returned exceed the maximum page width, 
and i have been unable to find a command that will prevent them from 
rounding.  Any help would be greatly appreciated.

thanks,

scott




_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to 
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.


_________________________________________________
Scanned for viruses on 24 Jan 2003 06:03:33
No viruses found.
Virus scanning by http://erado.com


_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail