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.Rajput@ipape To: [EMAIL PROTECTED]
r.com> cc:
Sent by: Subject: [ADMIN] ODBC error
pgsql-admin-owner@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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
