Re: HELP!!! Rounding Problem with Oracle and Delphi !!!!

Article View: borland.public.delphi.database

Article #2065

Back to borland.public.delphi.database Previous Next

#2065

From: Pablo Picasso
Date: Thu, 17 Sep 1998 00:00

47 lines
1593 bytes

Are you using 
.asBCD 
instead of
.asFloat 
inside your Delphi program ??

try this

Oliver

On Thu, 17 Sep 1998 11:41:11 +0200, "Equipe Outils"
<dvlmco02@societe-generale.com> wrote:

>Hi!
>We have a rounding problem when using the following configuration:
>  Oracle 7.3.3.4 on Open VMS on the server side
>with
>  Delphi 3.02,
>  BDE 4.51
>  and SQLNet 2.3.4 for Oracle on the client Side.
>
>We've defined on  a Numeric(17,3) on the Oracle DataBase
>
>**  If the parameter
>     Enable BCD := False
>We have a rounding problem on the value 99,999 that is set to 10!!!,
>this problem is on the client side  because the value 10 is set when exiting
>the related column.
>
>**  If the parameter
>     Enable BCD     := True
>No more rouding problem on the value 99,999 in this case !! but when we try
>to apply the updates to Oracle we have an ORA-1722 "Invalid Number" from
>Oracle.
>
>Has anybody faced this problem before???.
>We need some help!!
>
>Yasmina.
>
>
>
>
>
>
>
>

Technical Details

Message-ID: <36010969.189518262@news.newsguy.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6tql49$ast$1@jaydee.iway.fr>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10de66,64130236e29b0028
X-Google-Attributes: gid10de66,public
X-Google-Thread: 115d96,64130236e29b0028
X-Google-Attributes: gid115d96,public
From: Pablo.picasso@cyberdude.com (Pablo Picasso)
Subject: Re: HELP!!! Rounding Problem with Oracle and Delphi !!!!
Date: 1998/09/17
Message-ID: <36010969.189518262@news.newsguy.com>
X-Deja-AN: 392056081
References: <6tql49$ast$1@jaydee.iway.fr>
Organization: Hiasl Soft
Newsgroups: borland.public.delphi.database,borland.public.delphi.database.sqlservers

Reply to Parent Message