Re: Access and Boolean

I just created a table with a boolean field in
PostgreSQL and created a form in MS Access with which
to edit it.  The form allowed me to enter the
following characters with the following results:

entry     result
1         1
0         0
t         1
f         0
y         1
n         0

I am using PostgreSQL 7.1.3 on FreeBSD 4.4 and MS
Access 97 on Windows 98.  My PostgreSQL ODBC driver is
set to "Use Declare/Fetch".  (I don't know if that
matters.)

Perhap you could use a combo box in your Access form
to offer values acceptable to PostgreSQL.  This should
be a simple form edit.

When you "imported" Access tables into PostgreSQL, how
did you do it?  Perhaps the surest method of
conversion is to manually create the tables in
PostgreSQL and then use an Append query in MS Access
to move the data.  This is less efficient than
exporting a table via ODBC; but the results might be a
little better.

Have you reviewed the boolean data that was moved to
PostgreSQL to make sure it went across okay?

Best of luck,

Andrew Gould

--- Hauke de Vries <H.de.Vries@philos.rug.nl> wrote:
> I've imported some Access tables into PostgreSQL and
> Would like to
> use Access as frontend with linked tables.
>
> For modifying, updating, appending we use a form.
> Some fields have
> Boolean values (default 0). In Access this is
> expressed as '=No'.
> If we want it marked, i.e. set 'field' to 1, Access
> returns "The
> field is too small to accept the amount of data you
> are trying to
> add. Try inserting or paste less data."
>
> This is a remarkable 'feature' of Access returning
> -1 upon clicking.
> How to circumvent this behaviour?
>
> Hauke de Vries
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com