From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: Sean W. Ellis <sean.ellis@oscenter.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Check boxes with Access
Date: Tue, 14 Sep 1999 23:36:13 -0400
Message-ID: <37DF142D.EBC8AC8A@home.com> (raw)
References: <37DE718C.D1DA21E2@oscenter.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byron.nikolaidis@home.com, sean.ellis@oscenter.com
Subject: Re: [INTERFACES] Check boxes with Access
In-Reply-To: <37DF142D.EBC8AC8A@home.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox