Thread: select a non numeric fields problem

select a non numeric fields problem

From
daniel@sibtec.com.br
Date:
 I have one database postgres 8 and use delphi 7 as front end, in network windows.
 when giving select in sql explorer in one a table of postgres the result alone returns me only
 numeric fields from the table.
 the not numeric fields nao return in the result from query, although to be OK in the table
 who can help me with this?
 

Re: select a non numeric fields problem

From
"Dave Page"
Date:
 


From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of daniel@sibtec.com.br
Sent: 14 October 2005 12:43
To: daniel@sibtec.com.br; pgsql-odbc@postgresql.org
Subject: [ODBC] select a non numeric fields problem

 I have one database postgres 8 and use delphi 7 as front end, in network windows.
 when giving select in sql explorer in one a table of postgres the result alone returns me only
 numeric fields from the table.
 the not numeric fields nao return in the result from query, although to be OK in the table
 who can help me with this?
  
 
Some borland products (notably BDE) are known to not function properly with Unicode drivers. Please try using the ANSI driver instead.
 
Regards, Dave. 

Re: select a non numeric fields problem

From
"Merlin Moncure"
Date:
Are you using Unicode?
Have you tried the Zeos driver?

Merlin

________________________________________
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of daniel@sibtec.com.br
Sent: Thursday, October 13, 2005 6:41 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] select a non numeric fields problem

I have one database postgres 8 and use delphi 7 as front end, in network windows.
when giving select in sql explorer in one a table of postgres the result alone returns me only numeric  fields from the
table.
the not numeric fields nao return in the result from query, although to be OK in the table
alguem can help me with this?

Re: select a non numeric fields problem

From
"Merlin Moncure"
Date:
The BDE sucks.  I always send Borland people to the Zeos driver which replaces the BDE and the ODBC drivers and has
basicUnicode support.  They are invariably happier there. 

Merlin  
________________________________________ 
Some borland products (notably BDE) are known to not function properly with Unicode drivers. Please try using the ANSI
driverinstead. 
 
Regards, Dave.