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

Re: Access Bound Checkbox error for boolean field

From: "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Access Bound Checkbox error for boolean field
Date: 2001-10-30 18:46:58
Message-ID: 19AB8F9FA07FB0409732402B4817D75A038BFC@FILESERVER.SRF.srfarms.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Randy,

Under the Advance Options for the ODBC Drivers do you have 'Bools as Char'
Checked? If so uncheck it.

Ryan

> -----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
> 

Responses

pgsql-odbc by date

Next:From: Randall PerryDate: 2001-10-30 19:14:33
Subject: Re: Access Bound Checkbox error for boolean field
Previous:From: Randall PerryDate: 2001-10-30 18:15:53
Subject: Re: Access Bound Checkbox error for boolean field

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