From: Andrew Perrin - Demography <aperrin@demog.berkeley.edu>
To: pgsql-sql@postgresql.org
Subject: Access and field sizes
Date: Mon, 25 Oct 1999 16:49:07 -0700 (Pacific Daylight Time)
Message-ID: <Pine.WNT.4.05.9910251646200.153-100000@random.demog.berkeley.edu> (raw)
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
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: aperrin@demog.berkeley.edu
Subject: Re: Access and field sizes
In-Reply-To: <Pine.WNT.4.05.9910251646200.153-100000@random.demog.berkeley.edu>
References: <Pine.WNT.4.05.9910251646200.153-100000@random.demog.berkeley.edu>
* 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