ODBC( true = -1) and MS-Access

ODBC( true = -1) and MS-Access

am 29.09.2009 22:20:40 von Richard Broersma

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc