pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddelphi access question?
7+ messages / 6 participants
[nested] [flat]
* delphi access question?
@ 2005-03-30 20:15 Joel Fradkin <jfradkin@wazagua.com>
0 siblings, 1 reply; 7+ messages in thread
From: Joel Fradkin @ 2005-03-30 20:15 UTC (permalink / raw)
To: pgsql-sql; +Cc: pgsql-odbc@postgresql.org
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
lastran
lastupdated
active
and ftp_account
show up as fields I can add to the result.
Any ideas?
Joel Fradkin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ODBC] delphi access question?
@ 2005-03-30 20:53 Raymond O'Donnell <rod@iol.ie>
parent: Joel Fradkin <jfradkin@wazagua.com>
0 siblings, 0 replies; 7+ messages in thread
From: Raymond O'Donnell @ 2005-03-30 20:53 UTC (permalink / raw)
To: Joel Fradkin <jfradkin@wazagua.com>; +Cc: pgsql-general@postgresql.org
On 30 Mar 2005 at 15:15, Joel Fradkin wrote:
> 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.
Probably a silly question, but do you have all the fields SELECTed in
the SQL statement in the TQuery (or whatever you're using)?
If so, are you using persistent fields? If you are, have you tried
deleting them all from the fields editor and rebuilding them (right-
click on the empty fields editor and click on "Add all fields")?
--Ray.
-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
rod@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] delphi access question?
@ 2005-03-30 21:19 Gregory S. Williamson <gsw@globexplorer.com>
0 siblings, 3 replies; 7+ messages in thread
From: Gregory S. Williamson @ 2005-03-30 21:19 UTC (permalink / raw)
To: Joel Fradkin <jfradkin@wazagua.com>; pgsql-sql; +Cc: pgsql-odbc@postgresql.org
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
lastran
lastupdated
active
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?
http://archives.postgresql.org
!DSPAM:424b0a12126562811677690!
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] delphi access question?
@ 2005-03-30 21:36 Joel Fradkin <jfradkin@wazagua.com>
parent: Gregory S. Williamson <gsw@globexplorer.com>
2 siblings, 0 replies; 7+ messages in thread
From: Joel Fradkin @ 2005-03-30 21:36 UTC (permalink / raw)
To: 'Gregory S. Williamson' <gsw@globexplorer.com>; pgsql-sql; +Cc: pgsql-odbc@postgresql.org
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
lastran
lastupdated
active
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?
http://archives.postgresql.org
!DSPAM:424b0a12126562811677690!
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: delphi access question
@ 2005-03-31 04:22 Lin Kun Hsin <s9154083@cyut.edu.tw>
0 siblings, 0 replies; 7+ messages in thread
From: Lin Kun Hsin @ 2005-03-31 04:22 UTC (permalink / raw)
To: pgsql-sql
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://openwebmail.org)
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] delphi access question?
@ 2005-04-03 09:20 Andreas Pflug <pgadmin@pse-consulting.de>
parent: Gregory S. Williamson <gsw@globexplorer.com>
2 siblings, 0 replies; 7+ messages in thread
From: Andreas Pflug @ 2005-04-03 09:20 UTC (permalink / raw)
To: Gregory S. Williamson <gsw@globexplorer.com>; +Cc: Joel Fradkin <jfradkin@wazagua.com>; pgsql-odbc@postgresql.org
Gregory S. Williamson wrote:
> 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
> lastran
> lastupdated
> active
> and ftp_account
> show up as fields I can add to the result.
> Any ideas?
Are you using BDE with psqlodbc 8.0? I've seen problems with that, and
found only 7.0.0200 mostly working; any later version will show the
missing column problem.
Regards,
Andreas
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] delphi access question?
@ 2005-04-04 10:29 Miguel Juan <mjuan@cibal.es>
parent: Gregory S. Williamson <gsw@globexplorer.com>
2 siblings, 0 replies; 7+ messages in thread
From: Miguel Juan @ 2005-04-04 10:29 UTC (permalink / raw)
To: pgsql-odbc@postgresql.org
Hi,
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).
Regards,
Miguel Juan
----- Original Message -----
From: Gregory S. Williamson
To: Joel Fradkin ; pgsql-sql@postgresql.org
Cc: pgsql-odbc@postgresql.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
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
lastran
lastupdated
active
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?
http://archives.postgresql.org
!DSPAM:424b0a12126562811677690!
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2005-04-04 10:29 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-30 20:15 delphi access question? Joel Fradkin <jfradkin@wazagua.com>
2005-03-30 20:53 ` Raymond O'Donnell <rod@iol.ie>
2005-03-30 21:19 Re: [SQL] delphi access question? Gregory S. Williamson <gsw@globexplorer.com>
2005-03-30 21:36 ` Joel Fradkin <jfradkin@wazagua.com>
2005-04-03 09:20 ` Andreas Pflug <pgadmin@pse-consulting.de>
2005-04-04 10:29 ` Miguel Juan <mjuan@cibal.es>
2005-03-31 04:22 Re: delphi access question Lin Kun Hsin <s9154083@cyut.edu.tw>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox