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

Re: [SQL] delphi access question?

From: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
To: "'Gregory S(dot) Williamson'" <gsw(at)globexplorer(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:36:22
Message-ID: 001001c53570$84aee1b0$797ba8c0@jfradkin (view raw or whole thread)
Lists: pgsql-odbcpgsql-sql
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
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?



In response to

pgsql-odbc by date

Next:From: Joel FradkinDate: 2005-03-31 00:19:18
Subject: Re: delphi access question?
Previous:From: Gregory S. WilliamsonDate: 2005-03-30 21:19:29
Subject: Re: [SQL] delphi access question?

pgsql-sql by date

Next:From: Greg StarkDate: 2005-03-30 22:51:16
Subject: Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE
Previous:From: Robert TreatDate: 2005-03-30 21:23:34
Subject: Re: Postgres 7.3 migrate to 8.0 date problems.

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