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

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 (view raw or flat)
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

pgsql-odbc by date

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

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