From: Ross J. Reedstrom <reedstrm@rice.edu>
To: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Getting started with visual query builder in pgaccess
Date: Fri, 16 Apr 1999 11:58:19 -0500
Message-ID: <37176C2B.95F840C7@rice.edu> (raw)
References: <37166813.158A5@quoll.com>
Leon -
I'm going to make some wild gueses about parts of your question. I'd
guess you created this table by exporting it from an MS-Access database,
right? that's about the only way people commonly end up with MiXeD Case
field and tablenames. So, you're also using a version of pgaccess <0.96,
which doesn't deal with mixed case very well. Do the visual query
design, 'save to query', then edit the sql in the query window, to look
like:
select t0."fldIdNumber" from tblpeople t0 where (t0."fldIdNumber" > 1)
BTW, is it tblpeople, or people?
IF that works, upgrade your pgaccess, or submit a bugreport.
Leon Harris wrote:
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: reedstrm@rice.edu
Subject: Re: [INTERFACES] Getting started with visual query builder in pgaccess
In-Reply-To: <37176C2B.95F840C7@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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