Oracle. How to get negative numbers ?

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

Article #2886

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

#2886

From: Victor Cazacov
Date: Tue, 25 Feb 2003 08:15

20 lines
1722 bytes

I want to add that problem remains while accessing runtime created fields by
name.

CREATE TABLE XX_TST(
  F_INT NUMBER(9,0)
 )

ADOQuery->SQL->Text = "SELECT * FROM XX_TST"

  ADOQuery1->Open();
  ADOQuery1->Edit();
  ADOQuery1->FieldByName("F_INT")->AsInteger = -10;    // Negative value !!!
  ADOQuery1->Post();
  ADOQuery1->Requery();
  Caption = ADOQuery1->FieldByName("F_INT")->AsInteger;

Caption == "10".  Sign is lost.

--
Reagrds, Victor

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news-out.visi.com!hermes.visi.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

References:

<3e5a01b5$1@newsgroups.borland.com> <3e5a2a63@newsgroups.borland.com> <3e5a34d0@newsgroups.borland.com> <3e5a5db0$1@newsgroups.borland.com> <3e5b217f@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,e2ba085cccbd09f0
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-25 00:20:32 PST
Reply-To: "Victor Cazacov" <victor@kazakov.net>
From: "Victor Cazacov" <victor@kazakov.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3e5a01b5$1@newsgroups.borland.com> <3e5a2a63@newsgroups.borland.com> <3e5a34d0@newsgroups.borland.com> <3e5a5db0$1@newsgroups.borland.com> <3e5b217f@newsgroups.borland.com>
Subject: Oracle. How to get negative numbers ?
Date: Tue, 25 Feb 2003 09:15:52 +0100
Lines: 25
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: Victor Cazacov
FL-Build: Fidolook Express 2001 UIExt. BuildID: 3BC00FAD (7/10/2001 10:17:49).
NNTP-Posting-Host: 195.143.24.227
Message-ID: <3e5b26d3$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1046161107 195.143.24.227 (25 Feb 2003 00:18:27 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news-out.visi.com!hermes.visi.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message