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.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