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
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 |
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 |