X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BCB8552963 for ; Wed, 30 Mar 2005 21:52:59 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38819-05 for ; Wed, 30 Mar 2005 20:52:50 +0000 (GMT) Received: from mail2.mail.iol.ie (mail2.mail.iol.ie [193.95.141.54]) by svr1.postgresql.org (Postfix) with ESMTP id E93DA53A81 for ; Wed, 30 Mar 2005 21:52:49 +0100 (BST) Received: from dialup0547.ts551.cwt.esat.net ([193.203.142.35] helo=Nimrod) by mail2.mail.iol.ie with esmtp (Exim 3.36 #9) id 1DGkBB-0000fb-00; Wed, 30 Mar 2005 21:52:46 +0100 From: "Raymond O'Donnell" To: "Joel Fradkin" Date: Wed, 30 Mar 2005 21:53:01 +0100 MIME-Version: 1.0 Subject: Re: [ODBC] delphi access question? Cc: pgsql-general@postgresql.org Message-ID: <424B1FBD.16327.1846310@localhost> In-reply-to: <000001c53565$3a3d6bc0$797ba8c0@jfradkin> X-mailer: Pegasus Mail for Windows (4.21c) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.968 tagged_above=0 required=5 tests=AWL, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: X-Archive-Number: 200503/1525 X-Sequence-Number: 75840 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 -------------------------------------------------------------