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

ODBC( true = -1) and MS-Access

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC( true = -1) and MS-Access
Date: 2009-09-29 20:20:40
Message-ID: 396486430909291320p37bcc55cl5edd3d49f2401ff5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
I've configure the ODBC drawing to use true as -1.  However, I get the
following error message when Access tries to use -1 as true.

2009-09-29 13:12:15 PDTLOG:  statement:
  SELECT "MS1"."buildingnbr","MS1"."drawingnbr"
  FROM "public"."buildingdrawings" "MS1"
  WHERE (("buildingnbr" = 'B-1085' )
  AND ("haspressurization" = -1 ) )
ORDER BY "MS1"."drawingnbr"
2009-09-29 13:12:15 PDTERROR:  operator does not exist: boolean =
integer at character 146
2009-09-29 13:12:15 PDTHINT:  No operator matches the given name and
argument type(s). You might need to add explicit type casts.

The version of the odbc driver is 8.04.01.00.

Is this a bug?

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2009-09-29 20:32:07
Subject: Re: cannot find pg_hba.conf file
Previous:From: Ramon DiscuaDate: 2009-09-29 20:16:54
Subject: Re: cannot find pg_hba.conf file

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