Skip site navigation (1) Skip section navigation (2)

Re: v7.01.00.07 driver fails to properly report BOOL values

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Kristis Makris <kristis(dot)makris(at)datasoft(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: v7.01.00.07 driver fails to properly report BOOL values
Date: 2001-09-28 00:56:22
Message-ID: 3BB3CAB6.A2C7CCDF@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Kristis Makris wrote:
> 
> Hello all,
> 
> I took the v7 driver for a test drive and it looks like it properly
> reports all referential integrity errors reported from the backend (this
> was a bug in the v6). Kudos to the devel team; you guys are doing a
> superb job hunting down and fixing those bugs :)
> 
> I did come across something peculiar though. It seems to me that ever
> since I updated to the v7, the driver incorrectly reports the BOOL
> values retrieved from the backend. I first noticed this (?bug?) in the
> following snippet of code using VC++ and a CRecordset object.
> 
> **********************************************************************
> strStmt = "SELECT someBackendFunctionThatReturnsBOOL('someTextValue') AS
> answer";
> rsSelect.Open(CRecordset::forwardOnly, strStmt);
> 
>  if (db.CanTransact())
>    db.BeginTrans();
> 
>   while (!rsSelect.IsEOF())
>         {
>           rsSelect.GetFieldValue("answer", vID, SQL_C_SSHORT);
> 
>           rsSelect.MoveNext();
>         }
> **********************************************************************
> 
> After going through the debug mode of Visual Studio using both the v6
> and v7 drivers I verified that the value of vID.m_iVal was set to 1 if
> the BOOL return value was true and 0 if false using the v6 (and probably
> older versions v5, v4). Now the vID.m_iVal is always set to 0,
> regardless of the return value of the backend function.

Oops it's my fault sorry.
I would fix it ASAP.

Thanks for the report.
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-09-28 15:34:38
Subject: Re: Bug with ADORecordSet.Update
Previous:From: Keith GrayDate: 2001-09-27 23:15:34
Subject: Bug with ADORecordSet.Update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group