Thread: 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
> 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? Seems like it is having problems with your character fields. Are you using the BDE? If so, I'd strongly suggest checking out Zeos database objects and porting your app to use them at the same time. Merlin
That really works great thanks for the idea. Even I could get it installed and working and all my fields are showing up using the zeos sql object. Joel Fradkin Seems like it is having problems with your character fields. Are you using the BDE? If so, I'd strongly suggest checking out Zeos database objects and porting your app to use them at the same time. Merlin
> > Hate to fix it so the new odbc drivers work, but my Delphi application > doesn't. > Also if you had any experience with the newer odbc drivers and Unicode in > regards to issues I might see. > I tested my web page using a converted record (Unicode database) and it is > showing up ok now, but the old odbc will not display it, so I will not be > able to switch back easily. Zeos support for Unicode/postgresql is partial: http://web10086.xolphin.net/index.php?option=com_simpleboard&Itemid=&fun c=view&catid=101&id=1339#1339 however things may have improved since then. ymmv. I expect the new odbc driver should fix a lot of your odbc related problems. It's been a long time coming. Merlin
Is there a new one out? I was speaking of 8.0 vrs 7.4 I did just install the latest 8.0.3 win32 version of postgres and am using the odbc that comes with it. I guess I will test the Delphi app prior to getting excited about my last victory of getting my data in a Unicode database. Thanks for getting back in touch. Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. -----Original Message----- From: Merlin Moncure [mailto:merlin.moncure@rcsonline.com] Sent: Friday, July 01, 2005 3:49 PM To: Joel Fradkin Cc: pgsql-odbc@postgresql.org Subject: RE: [ODBC] delphi access question? > > Hate to fix it so the new odbc drivers work, but my Delphi application > doesn't. > Also if you had any experience with the newer odbc drivers and Unicode in > regards to issues I might see. > I tested my web page using a converted record (Unicode database) and it is > showing up ok now, but the old odbc will not display it, so I will not be > able to switch back easily. Zeos support for Unicode/postgresql is partial: http://web10086.xolphin.net/index.php?option=com_simpleboard&Itemid=&fun c=view&catid=101&id=1339#1339 however things may have improved since then. ymmv. I expect the new odbc driver should fix a lot of your odbc related problems. It's been a long time coming. Merlin