Skip site navigation (1) Skip section navigation (2)

Re: ODBC and Boolean

From: Grahame Jordan <gjordan(at)geicp(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC and Boolean
Date: 2007-01-10 10:42:06
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Richard Broersma Jr wrote:
>> I am using postgres8.1 on a Debian etch machine and am trying to port an 
>> access database to postgres.  I have installed the latest ODBC driver on 
>> WinXP ( and most things work OK.
>> The most problematic are the checkboxes.  At first they work OK but after a 
>> while when setting a checkbox we get an error that seems to keep on 
>> happening.
>> "The field is too small to accept the amount of data you attempted to add. Try 
>> inserting or pasting less data"
>> Once it gets in this state it seems to stick. Even tried rebooting.
>> I believe that the query is not getting past the ODBC driver as I can see no 
>> activity on the back end.
> I used the recommendation from this link and ever since I have not had any problems linking
> boolean fields to checkboxes.
> When I read threads like this, it makes me wish I know postgresql a whole lot better. :)
> Regards,
> Richard Broersma Jr.

Thanks for that. The problem was that we didn't refresh the tables.  All 
well now.


> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly

In response to

pgsql-odbc by date

Next:From: Titus BarikDate: 2007-01-11 19:54:25
Subject: GetData to Procedure return failed
Previous:From: Richard Broersma JrDate: 2007-01-10 01:54:15
Subject: Re: auto fill the missing numbers

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group