Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Crazy Rounding in SPT (Oracle)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Crazy Rounding in SPT (Oracle)
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Oracle
Divers
Thread ID:
01026096
Message ID:
01026096
Vues:
78
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform