From: Robert Chalmers <robert@chalmers.com.au>
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Subject: Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
Date: Tue, 19 Jan 1999 08:33:01 +1000
Message-ID: <36A3B69D.F91FCD46@chalmers.com.au> (raw)
References: <36A36B43.EBA270B4@mediacom.it>
Hi,
I'm pretty new to postgresql, but am reasonably familiar with MSAccess, and I
see here that Valerio can export tables from Access to pgsql. How is this done?
And using forms from Access related to pgsql databases?
This could be invaluable. While I'm at it, does anyone know where there might
be some sample code for a shopping cart using pgsql as the database and php3?
Thanks for any info, especialy on getting msaccess and postgresql working
together.
Robert
Valerio Santinelli wrote:
> 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
--
http://www.chalmers.com.au. Publications From China in 24 different languages.
English, French, German, Russian, Arabic, Spanish, Chinese, Burmese, Bengali,
Hindi, Indonesian, Italian, Japanese, Korean, Portuguese, Persian, Swahili,
Sinhalese, Thai, Tamil, Urdu, Vietnamese. China Books for CIBTC, Beijing.
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: robert@chalmers.com.au, pgsql-general@postgreSQL.org
Subject: Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL
In-Reply-To: <36A3B69D.F91FCD46@chalmers.com.au>
* 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