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: 45A4C2FE.8050001@geicp.com (view raw or flat)
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 (psqlodbc-08_02_0200.zip) 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.
> http://archives.postgresql.org/pgsql-odbc/2006-09/msg00103.php
>
> 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.

Cheers

Grahame
> ---------------------------(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-2014 The PostgreSQL Global Development Group