Only fails when logging is off

From: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Only fails when logging is off
Date: 2003-02-20 17:17:56
Message-ID: se549d65.080@groupwise.abag.ca.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Here is a problem that disappears when logging is on:
Attempting to issue the following SQL query from Access '97 against a postgres database:

SELECT tcompanies.company_id, CStr([tcompanies].[login_id]) & ": " & [tcompanies].[name] AS Expr1, tcompanies.name
FROM tcompanies
WHERE tcompanies.active
ORDER BY tcompanies.name;

column 'active' is boolean

2 messages ppear in succession
1. ODBC Call failed
2. ERROR: Unable to identify an operator "=" for types "boolean" and "integer"
You will have to retype this query using an explicit cast (#7)

Any ideas?

Fred Parkinson
Association of Bay Area Governments

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Renê Salomão 2003-02-20 19:30:46 Help Installing ODBC!!
Previous Message Hiroshi Inoue 2003-02-20 14:25:26 Re: Unicode, ODBC and MS Access