Re: ODBC error

Hi,

I updated the table definitions and changed the field type from numeric(18)
to int for the field I was linking the tables with. This solved the
problem. However, if a decimal field was required, I think this would
cause a big problem. Is there a workaround if a decimal field is required?
Thanks,

Devinder

"Devinder K Rajput"
<Devinder(dot)Rajput(at)ipape To: pgsql-admin(at)postgresql(dot)org
r.com> cc:
Sent by: Subject: [ADMIN] ODBC error
pgsql-admin-owner(at)post
gresql.org


10/29/2002 03:03 PM

Hi,

I am trying to create a report using Crystal Reports 8.0. I have
downloaded and installed the latest ODBC driver (hoping this would solve
the problem). I get the following error:

ODBC error: ERROR: Unable to identify an operator '=' for types
'numeric' and 'float8'
You will have to retype this query using an explicit cast

I looked on the web and saw some old references that said this was a
problem. I was wondering it is fixed or will it be fixed.

postgres: 7.1.3
ODDB: 7.2.3

Thanks,

Devinder

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster