Oracle and numeric values

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

Article #2249

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

#2249

From: Daevid Preis
Date: Mon, 15 Sep 2003 19:30

24 lines
1336 bytes

hi,

i tried to read various numeric values from an oracle database using
ado and cppbuilder 6.
but all i get is 32, every time, no matter whats really in the column.
here is the code that i�ve used. if u have any ideas, please email me.


CREATE TABLE u_user (
   UserID int NOT NULL,
   ...snip...
   Primary Key (UserID)
)


int *iBuffer = new int;
qryMain->SQL->Clear();
qryMain->SQL->Add("SELECT UserID FROM u_user");
qryMain->ExecSQL();
qryMain->GetFieldData(1, iBuffer);


thx and sorry for my bad english
daevid

Technical Details

Message-ID: <d61bab06.0309151130.3fc6aa57@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,7523c61a3624dc90,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-09-15 12:30:38 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: daevid@yaui.com (Daevid Preis)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Oracle and numeric values
Date: 15 Sep 2003 12:30:34 -0700
Organization: http://groups.google.com/
Lines: 24
Message-ID: <d61bab06.0309151130.3fc6aa57@posting.google.com>
NNTP-Posting-Host: 80.134.81.221
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1063654238 31890 127.0.0.1 (15 Sep 2003 19:30:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 15 Sep 2003 19:30:38 GMT