Only fails when logging is off

Поиск

Список

Период

Сортировка

От	Fred Parkinson
Тема	Only fails when logging is off
Дата	20 февраля 2003 г. 12:27:26
Msg-id	se549d65.080@groupwise.abag.ca.gov обсуждение исходный текст
Ответы	Re: Only fails when logging is off
Список	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

В списке pgsql-odbc по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Only fails when logging is off