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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Titus Barik | 2007-01-11 19:54:25 | GetData to Procedure return failed |
Previous Message | Richard Broersma Jr | 2007-01-10 01:54:15 | Re: auto fill the missing numbers |