TADOQuery doesn't fetch minus value correctly???

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

Article #2548

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

#2548

From: newbie
Date: Mon, 26 May 2003 09:38

14 lines
1313 bytes

CREATE TABLE TEST (
  COLUMN_A NUMBER(5)
);
INSERT INTO TEST VALUES(-2);
COMMIT;

/* CPP codes: */
  ADOQuery1->SQL->Add("SELECT COLUMN_A FROM TEST");
  ADOQuery1->Open();
  ShowMessage(ADOQuery1->FieldByName("COLUMN_A"));

It returns "2" instead of "-2"!!!
If you alter column COLUMN_A NUMBER or COLUMN_A NUMBER(10), the same codes works perfectly.

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!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,52ccf78e523140a3,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-05-26 02:41:30 PST
From: "newbie" <xlcheng@netkiss.com.cn>
Sender: "newbie" <xlcheng@netkiss.com.cn>
Reply-To: "newbie" <xlcheng@netkiss.com.cn>
Subject: TADOQuery doesn't fetch minus value correctly???
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 218.22.24.99 218.22.24.99    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3ed1e078$1@newsgroups.borland.com>
Date: 26 May 2003 02:38:00 -0700
X-Trace: newsgroups.borland.com 1053941880 207.105.83.65 (26 May 2003 02:38:00 -0700)
Lines: 14
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail