From: Valerio Santinelli <tanis@mediacom.it>
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Subject: Checkboxes on MSAccess and PostgreSQL
Date: Mon, 18 Jan 1999 18:11:31 +0100
Message-ID: <36A36B43.EBA270B4@mediacom.it> (raw)
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
?
Thanks again,
Valerio Santinelli
tanis@mediacom.it
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: tanis@mediacom.it, pgsql-general@postgreSQL.org
Subject: Re: Checkboxes on MSAccess and PostgreSQL
In-Reply-To: <36A36B43.EBA270B4@mediacom.it>
* 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