hello
I can run your sql statement in PgAdmin,too.
so your statement should be OK!
Can you post more example about add to result, let us have idea about your
question.
I think you can try to set char(1) to char(2), try it will useful..
--
http://alumni.cyut.edu.tw
Open WebMail Project (http:/
D]
Subject: [SQL] delphi access question?
One of my applications is in Delphi 5.
I just went to change it over to Postgres (from MSSQL).
I am using odbc and something a bit odd is happening.
I can run a sql statement ok, even in sql builder I see all the fields.
But the returned result set app
lto:[EMAIL PROTECTED]
Sent: Wed 3/30/2005 12:15 PM
To: pgsql-sql@postgresql.org
Cc: [EMAIL PROTECTED]
Subject: [SQL] delphi access question?
One of my applications is in Delphi 5.
I just went to change it over to Postgres (from MSSQL).
I am using odbc and something a bit odd is happen
One of my applications is in Delphi 5.
I just went to change it over to Postgres (from MSSQL).
I am using odbc and something a bit odd is happening.
I can run a sql statement ok, even in sql builder I see all the fields.
But the returned result set appears to be missing some of the fields.
So my ta
