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

Article View: borland.public.delphi.database

Article #2064

Back to borland.public.delphi.database Previous Next

#2064

From: Equipe Outils
Date: Thu, 17 Sep 1998 00:00

26 lines
1521 bytes

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: <6tql49$ast$1@jaydee.iway.fr>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,64130236e29b0028,start
X-Google-Attributes: gid115d96,public
X-Google-Thread: 10de66,64130236e29b0028,start
X-Google-Attributes: gid10de66,public
From: "Equipe Outils" <dvlmco02@societe-generale.com>
Subject: HELP!!! Rounding Problem with Oracle and Delphi !!!!
Date: 1998/09/17
Message-ID: <6tql49$ast$1@jaydee.iway.fr>
X-Deja-AN: 391995997
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-Complaints-To: abuse@iway.fr
X-Trace: jaydee.iway.fr 906024905 11165 194.98.4.131 (17 Sep 1998 09:35:05 GMT)
Organization: UUNet France
NNTP-Posting-Date: 17 Sep 1998 09:35:05 GMT
Newsgroups: borland.public.delphi.database,borland.public.delphi.database.sqlservers