Re: ADO returns positive values when they are negative in db !!!!!!

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/07/04 

Date: Tue, 06 Jan 2004 21:09:08 -0600

>Hello there.
>Working with Delphi 7 and ADO and Oracle 9 i have a nasty problem
>In my query I have 'SELECT HOURS FROM MyTable WHERE PIN=12'
>The value in the table is -56.
>In Delphi, the ADOQuery is returning +56 !!! (with the .asInteger or .asString option)
>The column in Oracle is NUMBER(4). When i try with a column in NUMBER(15) the result is good !?
>I have tried with every option on the TADOQuery component but it still doesn't work.

I suggest you use TbetterADODataset.
http://web.orbitel.bg/vassil/

This AdoDataset descendant fixes several problems with TadoDataset including
this one. It also has some extra features that make using ADO a lot easier 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com