Reading int fields from Oracle using ADO.

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

Article #2273

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

#2273

From: mreineck
Date: Sun, 28 Sep 2003 00:53

2 lines
1322 bytes

I am reading an integer field from an Oracle database using a TADOQuery component. The problem that I have is that it seems to take the absolute value of the actual data. For instance if the database has five records with values of -2, -1, 0, 1, 2 and what I read is 2, 1, 0, 1, 2. This is true even if I access the value as AsString (in this case I get "2", "1", "0", "1", "2"). Does anyone know anything about this or how to fix it?

Technical Details

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

Path:

arc1-ca.pugleaf.net!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b9403a01a9502ee0,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-09-27 18:09:52 PST
From: "mreineck" <mreineck@cinci.rr.com>
Sender: "mreineck" <mreineck@cinci.rr.com>
Reply-To: "mreineck" <mreineck@cinci.rr.com>
Subject: Reading int fields from Oracle using ADO.
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 24.106.86.149     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <3f7630fa$1@newsgroups.borland.com>
Date: 27 Sep 2003 17:53:14 -0700
X-Trace: newsgroups.borland.com 1064710394 207.105.83.66 (27 Sep 2003 17:53:14 -0700)
Lines: 2
Path: arc1-ca.pugleaf.net!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail