Re: ADO not able to read a negative number from database

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

Article #1564

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

#1564

From: Arnie Mauer
Date: Mon, 17 May 2004 19:56

26 lines
1765 bytes

"aderiggi" <derigga@dbcc.edu> wrote in message
news:40a9162f$1@newsgroups.borland.com...
> I am using an ADO connection and ADO Query Components. I am connecting to
a informix database. The column definitions are integers.
> The following is the sql statement I am running:
>
> select (xxx.max_reg - xxx.reg_num)seats
> from xxx
> where crs_no = 'xxx' and sec_no = 'xx' and yr=xxxx and sess='xx'
>
> max_reg = 30
> reg_reg = 32
> seats should = -2
>
> I get 2 back using the ADO components.
> I get -2 (the correct value) using the BDE components.
>
> - Anthony
>
Hmmm.  I don't know.  You can try replacing the column names with literals,
eg (30 - 32), and see what you get.  We're using Oracle, DB2 and SQL Server
and don't have the problem.

What OLEDB driver are you using?

- Arnie

Technical Details

Message-ID: <40a91925@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsrout1.ntli.net!news-in.ntli.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <40a91228$1@newsgroups.borland.com> <40a912a5$1@newsgroups.borland.com> <40a9162f$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,8e06cfa3972c7348
X-Google-Attributes: gid10698b,public
From: "Arnie Mauer" <xxx@nowhere.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <40a91228$1@newsgroups.borland.com> <40a912a5$1@newsgroups.borland.com> <40a9162f$1@newsgroups.borland.com>
Subject: Re: ADO not able to read a negative number from database
Date: Mon, 17 May 2004 15:56:41 -0400
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 209.140.211.97
Message-ID: <40a91925@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1084823845 209.140.211.97 (17 May 2004 12:57:25 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsrout1.ntli.net!news-in.ntli.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message