X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 634AF53568;
	Wed, 30 Mar 2005 22:36:15 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 54141-09; Wed, 30 Mar 2005 21:36:10 +0000 (GMT)
Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48])
	by svr1.postgresql.org (Postfix) with ESMTP id 7AB2153865;
	Wed, 30 Mar 2005 22:36:09 +0100 (BST)
Received: from jfradkin ([66.15.127.235])
	by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix
	0.04 (built Dec 24 2004)) with ESMTPA id
	<0IE6007D7PCBN8G1@vms048.mailsrvcs.net>;
	Wed, 30 Mar 2005 15:36:11 -0600 (CST)
Date: Wed, 30 Mar 2005 16:36:22 -0500
From: "Joel Fradkin" <jfradkin@wazagua.com>
Subject: Re: [SQL] delphi access question?
In-reply-to: 
 <71E37EF6B7DCC1499CEA0316A256832801D4C03B@loki.wc.globexplorer.net>
To: "'Gregory S. Williamson'" <gsw@globexplorer.com>,
	<pgsql-sql@postgresql.org>
Cc: <pgsql-odbc@postgresql.org>
Message-id: <001001c53570$84aee1b0$797ba8c0@jfradkin>
MIME-version: 1.0
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Mailer: Microsoft Outlook, Build 10.0.6626
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: quoted-printable
Importance: Normal
X-Priority: 3 (Normal)
X-MSMail-priority: Normal
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.52 tagged_above=0 required=5 tests=AWL
X-Spam-Level: *
X-Archive-Number: 200503/134
X-Sequence-Number: 5152

Yea odd thing is if I use a table type object it see the fields so it is
only with query objects.

The same odbc works ok with my asp pages.

I will see if I can figure out the zeos stuff.

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
DBA
GlobeXplorer LLC

-----Original Message-----
From:	Joel Fradkin [mailto:jfradkin@wazagua.com]
Sent:	Wed 3/30/2005 12:15 PM
To:	pgsql-sql@postgresql.org
Cc:	pgsql-odbc@postgresql.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
  transnumber=20
  lastran
  lastupdated
  active
  and ftp_account
show up as fields I can add to the result.
Any ideas?


Joel Fradkin
=20
=20



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

               http://archives.postgresql.org

!DSPAM:424b0a12126562811677690!