🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Number datatype being shown as a ftBCD

#2563
From: John Z Fields
Date: Tue, 27 May 2003 15:09
11 lines
1395 bytes
Hi all. I have a column defined as Number(10) in an Oracle 9i table. After
retrieving a dataset from this table, the Oracle ADO provider identifies the
column as ftBCD with size 0, which is correct cause it is a whole number,
but datasize 33, which is incorrect. Please advise if you have encountered a
similar situation. I need to know that it is a number 10 column so that I
can set maxlength on the control to 10.

thanks much.

-- 
JOHN FIELDS
Technical Details
Message-ID: <3ed37f8c$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,7918b403313ee00a,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-05-27 08:32:07 PST
Reply-To: "John Z Fields" <jfields@wrsystems.com>
From: "John Z Fields" <jfields@wrsystems.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Number datatype being shown as a ftBCD
Date: Tue, 27 May 2003 11:09:01 -0400
Lines: 13
Organization: WR Systems
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 63.90.140.53
Message-ID: <3ed37f8c$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1054048140 63.90.140.53 (27 May 2003 08:09:00 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail