ODBC error

Поиск
Список
Период
Сортировка
Искать

ODBC error

От:
"Devinder K Rajput" <Devinder.Rajput@ipaper.com>
Дата:
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


Re: ODBC error

От:
"Devinder K Rajput" <Devinder.Rajput@ipaper.com>
Дата:

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





FAQ