Geoff Muldoon wrote:
> damorgan@psoug.org says...
>> beerora wrote:
>>> I am using Foxpro to extract data from ORACLE9i. I am connected
>>> through ODBC. One of the field in DB is number. When I retrieve the
>>> data from DB by FOXPRO the result is not ROUNDER or TRUNCATED. But the
>>> same query when I use in SQL Worksheet, the result is either ROUNDED or
>>> TRUNCATED to one decimal point.
>>>
>>> E.g., if the value is 2345678.95 then it is rounded to 2345679.0
>>> if the value is 234567.23 then it is truncated to 234567.30
>>>
>>> Can anyone help me why SQL worksheet behave this way?
>> What do you want to do? Just use the appropriate function.
>>
>> SELECT TRUNC(<column_name>) or SELECT ROUND(<column_name>, <places>)
>
> Daniel,
>
> I think the OP is wanting the reverse, setting the format mask in SQL
> Worksheet for a higher/not limited level of precision than his current
> defaults are providing.
>
> GM

Don't have the product so if that is the question I can't comment.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org