From: Leon Harris <leon@quoll.com>
To: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Getting started with visual query builder in pgaccess
Date: Fri, 16 Apr 1999 06:28:36 +0800
Message-ID: <37166813.158A5@quoll.com> (raw)
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
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: leon@quoll.com
Subject: Re: Getting started with visual query builder in pgaccess
In-Reply-To: <37166813.158A5@quoll.com>
* 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