Thread: Getting started with visual query builder in pgaccess

Hi to all.
Please forgive my newness to postgres and pgaccess.
I am trying to get started using pgaccess. I can't seem to find much
doccumentation on the visual query builder, as well as other things.

Could someone please tell me what I am doing wrong here?

I start with a table called people

people
----------------|----------
fldIdNumber    |
fldFirstName     |
fldLastName     |



I add this table to the visual designer, and then I drag and drop the
fldIdNumber into the field row. The designer inserts the table name, and
then I change criteria to  > 1 - meaning I want to return all First and
last names whose Idnumber is greater than 1.

All that happens is I get a syntax error. The sql I wanted was something
like
select * from tblpeople where ( fldIdNumber > 1).

Instead, I get
select t0.fldIdNumber from tblpeople where (t0.fldIdNumber > 1)

I have also tried this without uppercase. Is there any sort of decent
tutorial for pgaccess?

what is happenning here?

TIA
Leon Harris

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