| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma | 2009-09-29 20:32:07 | Re: cannot find pg_hba.conf file |
| Previous Message | Ramon Discua | 2009-09-29 20:16:54 | Re: cannot find pg_hba.conf file |