Hi All,

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?

Thanks & Regards,
beerSA

beerora wrote:
> Hi All,
>
> 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?
>
> Thanks & Regards,
> beerSA

What do you want to do? Just use the appropriate function.

SELECT TRUNC(<column_name>) or SELECT ROUND(<column_name>, <places>)
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

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

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