Thread: delphi access question?

delphi access question?

From
"Joel Fradkin"
Date:
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
 
 



Re: delphi access question?

From
"Merlin Moncure"
Date:
> 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

Re: delphi access question?

From
"Joel Fradkin"
Date:
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


Re: delphi access question?

From
"Merlin Moncure"
Date:
>
> 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

Re: delphi access question?

From
"Joel Fradkin"
Date:
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