Message-Id: <36A36D59.D6064F6A@insightdist.com>
Date: Mon, 18 Jan 1999 12:20:25 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: Valerio Santinelli <tanis@mediacom.it>
Cc: "pgsql-general@postgreSQL.org" <pgsql-general@postgreSQL.org>
Subject: Re: [GENERAL] Checkboxes on MSAccess and PostgreSQL
References: <36A36B43.EBA270B4@mediacom.it>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Valerio Santinelli wrote:

> First of all.. thanks to everybody for helping me out witht the
> "sequence" stuff. :)
>
> I've got another questions for you dudes.  When using a CheckBox in a
> Form written in MSAccess that's related to a table in a
> PostgreSQL database, if I simply turn its status from ON to OFF it works
> fine, while if i'm doing the opposite it won't work.
>
> I noticed that when exporting the table from MSAccess to PostgreSQL the
> "yes/no" fields all became char(1) and not boolean.. maybe this could be
> the problem.
>
> I also noticed from the logs that when updating the status from ON to
> OFF the UPDATE goes out with something like field_name='0'
> I'm not sure it should use the "'" since it's more like a numerical, no
> ?
>

Try setting the Advanced Driver Option "Bools as Char" to disabled.   This
will cause the export to use a Boolean field in postgres.

Byron