Message-ID: <37DF142D.EBC8AC8A@home.com>
Date: Tue, 14 Sep 1999 23:36:13 -0400
From: Byron Nikolaidis <byron.nikolaidis@home.com>
Organization: @Home Network
MIME-Version: 1.0
To: "Sean W. Ellis" <sean.ellis@oscenter.com>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Check boxes with Access
References: <37DE718C.D1DA21E2@oscenter.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


"Sean W. Ellis" wrote:
> 
> I have been extremely pleased with Postgres.  And, using Access now as a
> front-end is great using the ODBC driver.  However, I cannot figure out
> how to use checkboxes.
> 
> Any insight or VB code as a work-around ?
> 
> Thank you,
> 
> Sean Ellis, sean.ellis@oscenter.com
> Office Systems Center, 110 N. Main, Victoria, TX 77901 (361) 575-6886
> 
> ************

Checkboxes should be used with boolean columns types.   There is a odbc
driver option called "bools as char" that should NOT be checked if you
are using a boolean data type for that column.   Alternatively, you
could use a character type for a column, and turn on the bools as char
feature, and it should work also.

If you still have problems, look at the driver's logfile and see what
sql statement was sent to try and alter a checkbox field.  That should
show exactly what the problem is.

Byron