Skip site navigation (1) Skip section navigation (2)

Re: [SQL] delphi access question?

From: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
To: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [SQL] delphi access question?
Date: 2005-03-30 21:19:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbcpgsql-sql
Something is not translating CHAR values correctly -- all the fields that you "see" are not char values.

Have no idea off hand *why* this would be ... character encoding differences maybe ?

Greg Williamson
GlobeXplorer LLC

-----Original Message-----
From:	Joel Fradkin [mailto:jfradkin(at)wazagua(dot)com]
Sent:	Wed 3/30/2005 12:15 PM
To:	pgsql-sql(at)postgresql(dot)org
Cc:	pgsql-odbc(at)postgresql(dot)org
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 appears to be missing some of the fields.
So my table is
CREATE TABLE tbltranslations
  transnumber int4 NOT NULL,
  clientnum char(4) NOT NULL,
  lastran timestamp,
  lastupdated timestamp,
  firstrowhasheading char(1),
  fixed_delimited char(1),
  tblname varchar(50),
  delimeter char(1),
  textqualifier char(1),
  active bool,
  direction char(1),
  client_filename varchar(250),
  ftp_account int4,
  fixedlenghthascomma char(1),
  ftp_path varchar(250),
  ftp_filename varchar(50),
  fieldname_forid_on_insert varchar(50)
but only fields
  and ftp_account
show up as fields I can add to the result.
Any ideas?

Joel Fradkin

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?




pgsql-odbc by date

Next:From: Joel FradkinDate: 2005-03-30 21:36:22
Subject: Re: [SQL] delphi access question?
Previous:From: Merlin MoncureDate: 2005-03-30 21:19:10
Subject: Re: delphi access question?

pgsql-sql by date

Next:From: Robert TreatDate: 2005-03-30 21:23:34
Subject: Re: Postgres 7.3 migrate to 8.0 date problems.
Previous:From: Robert TreatDate: 2005-03-30 20:54:48
Subject: save me from an unconstrained join

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group