From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: [INTERFACES] Getting started with visual query builder in pgaccess |
Date: | 1999-04-16 16:58:19 |
Message-ID: | 37176C2B.95F840C7@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Yu Cao | 1999-04-17 03:03:00 | TBLOCK status from libpq / libpq++ |
Previous Message | Pavel PaJaSoft Janousek | 1999-04-16 10:03:09 | Selecting more columns in ECPG in one select - error? |