[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] ODBC error
From:       "Devinder K Rajput" <Devinder.Rajput () ipaper ! com>
Date:       2002-10-29 21:35:11
[Download RAW message or body]


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:     pgsql-admin@postgresql.org   \
                
                    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


[prev in list] [next in list] [prev in thread] [next in thread]