Oracle. How to get negative numbers ?

Article View: borland.public.cppbuilder.database.ado

Article #2879

Back to borland.public.cppbuilder.database.ado Previous Next

#2879

From: Victor Cazacov
Date: Mon, 24 Feb 2003 11:25

24 lines
1745 bytes

Simple example to show my problem:
CREATE TABLE XX_TST(
  F_INT NUMBER(9,0)
 )

 INSERT INTO XX_TST VALUES ( 1)
 INSERT INTO XX_TST VALUES (-1)     // Negative value !!!!!!!

When I put TADOQuery component and execute query "SELECT * FROM XX_TST"
I get dataset with two rows both containing value "1" !

If I use NUMBER field type instead NUMBER(9,0), sign is not lost. It seems
that problem occurs with types that are maped to TIntegerField class (NUMBER
is maped to BCD).

Is there any workaround ? I can not change field type to NUMBER, because I
need compatibility with Sybase (INTEGER field type).

MDAC 2.7
Oracle 8i
BCB6 (with all patches)

--
Regards, Victor

Technical Details

Message-ID: <3e5a01b5$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,e2ba085cccbd09f0,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-24 03:31:11 PST
Reply-To: "Victor Cazacov" <victor@kazakov.net>
From: "Victor Cazacov" <victor@kazakov.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Oracle. How to get negative numbers ?
Date: Mon, 24 Feb 2003 12:25:14 +0100
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Comment-To: All
FL-Build: Fidolook Express 2001 UIExt. BuildID: 3BC00FAD (7/10/2001 10:17:49).
NNTP-Posting-Host: 195.143.24.227
Message-ID: <3e5a01b5$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1046086069 195.143.24.227 (24 Feb 2003 03:27:49 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail