From: Olaf Mittelstaedt <mstaedt@va-sigi.va.fh-ulm.de>
To: pgsql-interfaces@postgreSQL.org
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Postgres ODBC and SQL_BIT
Date: Thu, 3 Sep 1998 07:34:28 +0100
Message-ID: <199809030535.HAA08990@gate.va.fh-ulm.de> (raw)
In-Reply-To: <35ED7971.F5639931@insightdist.com>
> MS Access will not take any ODBC SQL data type and translate it into a check box.
> Other tool may do this but not MS Access. Access only supports check boxes on
> Access databases.
>
> As for what Access it will do - The psqlodbc driver as options to treat postgresql
> bools as SQL_CHAR (t/f) or or SQL_BIT. MS Access displays SQL_BIT as -1/0.
When migrating a database from native Access to Postgres I replaced
Boolean with Integers (0=false, -1=true), I had no problems to use
checkboxes connected with those fields.
Regards,
Olaf
--
Olaf Mittelstaedt - IuK - mittelstaedt@fh-ulm.de
Fachhochschule Ulm Prittwitzstr. 10 89075 Ulm
Tel.: +49 (0)731-502-8220 Fax: -8270
Ash nazg durbatulûk, ash nazg gimbatul,
ash nazg thrakatulûk agh burzum-ishi krimpatul.
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: mstaedt@va-sigi.va.fh-ulm.de
Subject: Re: [INTERFACES] Postgres ODBC and SQL_BIT
In-Reply-To: <199809030535.HAA08990@gate.va.fh-ulm.de>
* 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