sign lost when connecting to oracle 9/8 via ado, help needed!

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

Article #2422

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

#2422

From: Alain Bourgeois
Date: Fri, 25 Jul 2003 17:25

34 lines
1886 bytes

Dear all,


I encounter a serious problem when querying oracle 8.0.5 and oracle
9.2.0.1.0.
I have an oracle table Datas(VAL NUMBER(8,0)), and I inserted two
values:
insert into Datas values(-1);
insert into Datas values(-2);
Commit;
When I set this table in a grid (using a TADOConnection, a TSQLQuery, a
TDataSource and a TDBGrid), I get for select * from datas:
Datas
------
1
2

And I should receive -1, -2.

When connecting via bde to oracle 8 or to oracle 8/9 via dbExpress, it
works.
If, in ms-access vb, I open an ado connection to oracle, and read
fields, I get -1,-2.

It seems that bcb6 is not able to get negative numbers via ADODB
components and oracle.
This bug is quite severe!!!
Can someone help?


Alain Bourgeois
ps : please if you put my e-mail in cc of your answer, it would be
great!
a.bourgeois@cardsencodingcy.be

Technical Details

Message-ID: <3F2167F1.9837BDDC@skynet.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!skynet.be!skynet.be!louie!tlk!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b63725609913281c,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-07-25 10:21:07 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!skynet.be!skynet.be!louie!tlk!not-for-mail
Message-ID: <3F2167F1.9837BDDC@skynet.be>
Date: Fri, 25 Jul 2003 19:25:06 +0200
From: Alain Bourgeois <bk332951@skynet.be>
Reply-To: albourg@advalvas.be
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: sign lost when connecting to oracle 9/8 via ado, help needed!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 35
Organization: -= Belgacom Usenet Service =-
NNTP-Posting-Host: 80.200.228.125
X-Trace: 1059153661 reader0.news.skynet.be 278 80.200.228.125:3512
X-Complaints-To: usenet-abuse@skynet.be