🚀 go-pugleaf

"�̿��" <ydlee@medique.co.kr> wrote in message
news:3fd3ee0b@newsgroups.borland.com...
> I created a table in mssql using
>
>    CREATE TABLE sample (value BIGINT)
>
> And I inserted a value using
>
>    INSERT INTO sample VALUES (-12345)
>
> Now if I tried to read the value usind TADOQuery as follows, I get 12345,
> not -12345.
>
>   __int64 value;
>
>    query = "SELECT * FROM sample";
>
>    tADOQuery->SQL->Clear();
>    tADOQuery->SQL->Text = query.Trim();
>
>    try
>    {
>       tADOQuery->Open();
>    }
>    catch (Exception &e)
>    {
>       return;
>    }
>
>    if (tADOQuery->RecordCount > 0)
>       value = dynamic_cast<TLargeintField
> *>(tDataSource->DataSet->Fields->FindField("value"))->AsLargeInt;
>
> Can anybody tell me what I am doing wrong? Thanks in advance.
>
> --
>
> Yongduk Lee
> ydlee@medique.co.kr
>
>

This looks like a bug to me.  I can duplicate the problem.  When I use a
genreal purpose DB tool and read the column via ODBC, I get the
expected -12345.

-- Arnie