Re: Access Bound Checkbox error for boolean field

on 10/30/01 1:46 PM, Ryan C. Bonham at Ryan(at)srfarms(dot)com wrote:

> Randy,
>
> Under the Advance Options for the ODBC Drivers do you have 'Bools as Char'
> Checked? If so uncheck it.
>
> Ryan
>
That was it. Thanks, was tearing what little hair I have out over that one.

The only setting I changed in the PgSQL ODBC driver was 'Read Only'. I guess
'Bools as Char' is a default.

Any other ODBC driver settings I should know about?

>> -----Original Message-----
>> From: Randall Perry [mailto:rgp(at)systame(dot)com]
>> Sent: Tuesday, October 30, 2001 1:16 PM
>> To: pgsql-odbc(at)postgresql(dot)org
>> Subject: Re: [ODBC] Access Bound Checkbox error for boolean field
>>
>>
>> on 10/29/01 8:59 PM, Randall Perry at rgp(at)systame(dot)com wrote:
>>
>>> Am getting the following error with a bound checkbox field
>> in Access 2000
>>> when I try to toggle it:
>>>
>>> 'field is too small to accept the amount of data you are
>> trying to enter'
>>>
>>> Anyone know the fix?
>>>
>> Actually, it's Access XP, and the reason for the error is
>> that my PgSQL
>> boolean field is being mapped to a TEXT field in Access.
>>
>> How do I fix this? Or do I?
>>
>>
>> --
>> Randy Perry
>> sysTame
>> Mac Consulting/Sales
>>
>> phn 561.589.6449
>> mobile email help(at)systame(dot)com
>>
>>
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/users-lounge/docs/faq.html
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: 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
>

--
Randy Perry
sysTame
Mac Consulting/Sales

phn 561.589.6449
mobile email help(at)systame(dot)com