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

Re: [SQL] delphi access question?

From: "Miguel Juan" <mjuan(at)cibal(dot)es>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [SQL] delphi access question?
Date: 2005-04-04 10:29:58
Message-ID: 002301c53901$401892f0$07c8a8c0@miguel2000 (view raw, whole thread or download thread mbox)
Lists: pgsql-odbcpgsql-sql

 I don't know if this may help but after comparing the mylog.log files I
have noticed that it looks like the copy_and_convert function recives a
fctype=-9999 in version 8, while it recives a fctype=1 in version 7.3.

It doesn't matter the encoding of the database, becouse I have tried it with
SQL_ASCII, LATIN1 and UNICODE with the same results.

This also afect to MS-Access, all the text field values appear like
"deleted" ("Eliminado" in spanish).


Miguel Juan

----- Original Message ----- 
From: Gregory S. Williamson
To: Joel Fradkin ; pgsql-sql(at)postgresql(dot)org
Cc: pgsql-odbc(at)postgresql(dot)org
Sent: Wednesday, March 30, 2005 11:19 PM
Subject: Re: [ODBC] [SQL] delphi access question?

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?



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

pgsql-odbc by date

Next:From: yue chenDate: 2005-04-06 00:07:36
Subject: Problem with download
Previous:From: Per Erik R=?ISO-8859-1?B?+A==?=nneDate: 2005-04-04 03:47:22
Subject: ODBC on MacOS X

pgsql-sql by date

Next:From: Richard HuxtonDate: 2005-04-04 10:39:56
Subject: Re: select & group by
Previous:From: Michael L. HostbaekDate: 2005-04-04 10:16:47
Subject: select & group by

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