Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crazy Rounding in SPT (Oracle)
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Crazy Rounding in SPT (Oracle)
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Oracle
Miscellaneous
Thread ID:
01026096
Message ID:
01026096
Views:
76
Hello Everyone!!
This is somthing strange that I can't figure out.
I have a Function that resides in a Package that is on My Oracle Database.
I am connecting using ORACLE ODBC DRIVER

when I run it directly from oracle, I get 0.0575

When I use SQL Passthrough Using the exact same call I get 0.06.

I have gone into my options and changed my decimals to show 4 places and it stills says 0.06

I don't understand.

Is there a setting that I am not looking at or something that I could change to make this look correct?
In my Function, There is no rounding. In My call, There is no rounding.
Am I missing something?


Thanks in advance
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide

LeRoy Jackson
Next
Reply
Map
View

Click here to load this message in the networking platform