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
 
 

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(at)iol(dot)ie Galway Cathedral Recitals
-------------------------------------------------------------