Re: ERROR: invalid input syntax for type boolean: "-"(#7) - Mailing list pgsql-odbc

From Dave Page
Subject Re: ERROR: invalid input syntax for type boolean: "-"(#7)
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4306878@ratbert.vale-housing.co.uk
Whole thread Raw
In response to ERROR: invalid input syntax for type boolean: "-"(#7)  (Peter van Heck <usenet@heckwork.nl>)
List pgsql-odbc

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Peter van Heck
> Sent: 29 September 2004 02:53
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ERROR: invalid input syntax for type boolean: "-"(#7)
>
> I get this error with an ms-access front-end boolean type
> field where access produces "-1" and Postgresql's bool field
> does not accept this.
>
> Im using Postgres 7.4.5, Access 2002, mdac 2.8, psqlodbc-07_03_0200.
>
> Is there a proper work around?

There is a 'True is -1' option on the second options dialog.

Regards, Dave

pgsql-odbc by date:

Previous
From: Xiang Zhang
Date:
Subject: How to Access the MS SQL Server via ODBC from Redhat Linux
Next
From: "Dave Page"
Date:
Subject: Re: problems with the ODBC driver