pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Juarez Rudsatz <juarez@correio.com>
To: pgsql-sql@hub.org
Subject: Re: pgsql-sql-digest V1 #393
Date: Tue, 26 Oct 1999 09:16:08 -0200
Message-ID: <000901bf1fa3$80f2f680$270110ac@psmi.intranet> (raw)
References: <199910260300.XAA06890@hub.org>


> Date: Mon, 25 Oct 1999 16:49:07 -0700 (Pacific Daylight Time)
> From: Andrew Perrin - Demography <aperrin@demog.berkeley.edu>
> Subject: Access and field sizes
>
> Greetings-
>
> I'm in the process of porting a database from Access to postgres, and have
> run into a snag.  The snag involves boolean fields using checkboxes in
> Access forms; they always return a useless Microsoftish error:
>
> The field is too small to accept the amount of data you attempted to add.
> Try inserting or pasting less data.
>
> This happens when a checkbox is clicked to set a boolean value to True,
> but not when it is clicked to set the value back to False.
>
> Does anyone have any experience or idea where to go with this?
>
> Thanks-
> Andy Perrin
>
> - ---------------------------------------------------------------------
> Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
> Department of Demography    -    University of California at Berkeley
> 2232 Piedmont Avenue #2120  -    Berkeley, California, 94720-2120 USA
> http://demog.berkeley.edu/~aperrin --------------------------SEIU1199
>

    Recently I has a little problem with boolean fields in ODBC access to
postgres. The type of field was char. In the ODBC driver configuration there
are a advanced option : "Bool as char". Take a look.

Juarez Rudsatz





Message-ID: <000901bf1fa3$80f2f680$270110ac@psmi.intranet>
Permalink:  ../000901bf1fa3$80f2f680$270110ac@psmi.intranet/
Also on:    postgresql.org/message-id/000901bf1fa3$80f2f680$270110ac@psmi.intranet

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: juarez@correio.com, pgsql-sql@hub.org
  Subject: Re: pgsql-sql-digest V1 #393
  In-Reply-To: <000901bf1fa3$80f2f680$270110ac@psmi.intranet>
  References: <199910260300.XAA06890@hub.org> <000901bf1fa3$80f2f680$270110ac@psmi.intranet>

* 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