Checkboxes on MSAccess and PostgreSQL

From: Valerio Santinelli <tanis(at)mediacom(dot)it>
To: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Checkboxes on MSAccess and PostgreSQL
Date: 1999-01-18 17:11:31
Message-ID: 36A36B43.EBA270B4@mediacom.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

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(at)mediacom(dot)it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Byron Nikolaidis 1999-01-18 17:20:25 Re: [GENERAL] Checkboxes on MSAccess and PostgreSQL
Previous Message Memphisto 1999-01-18 16:49:16 On the int8 type support

Browse pgsql-interfaces by date

  From Date Subject
Next Message Byron Nikolaidis 1999-01-18 17:20:25 Re: [GENERAL] Checkboxes on MSAccess and PostgreSQL
Previous Message Frank Morton 1999-01-18 03:43:12 JDBC Table Methods