Re: Either I broke PostgreSQL or I found an ODBC bug

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: Postgresql ODBC List <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Either I broke PostgreSQL or I found an ODBC bug
Date: 2007-11-07 12:15:37
Message-ID: 14958.25889.qm@web31808.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

--- On Tue, 11/6/07, Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> wrote:

> Unfortunately, Access 95 onwards do not permit Null values in
> Yes/No fields.

That explains why I was see FALSE instead of NULL. As a work around, I've altered all of the boolean fields to be NOT NULL with a DEFAULT value as FALSE. Now MS-access is able to update these records without complaining.

Thanks!
Regards,
Richard Broersma Jr.

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Сергей Демьяненко 2007-11-08 08:54:48 Re: Access violation in psqlodbcw.dll
Previous Message Hiroshi Inoue 2007-11-07 08:14:51 Re: Access violation in psqlodbcw.dll