pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Getting started with visual query builder in pgaccess 2+ messages / 2 participants [nested] [flat]
* Getting started with visual query builder in pgaccess @ 1999-04-15 22:28 Leon Harris <leon@quoll.com> 1999-04-16 16:58 ` Re: [INTERFACES] Getting started with visual query builder in pgaccess Ross J. Reedstrom <reedstrm@rice.edu> 0 siblings, 1 reply; 2+ messages in thread From: Leon Harris @ 1999-04-15 22:28 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] Getting started with visual query builder in pgaccess 1999-04-15 22:28 Getting started with visual query builder in pgaccess Leon Harris <leon@quoll.com> @ 1999-04-16 16:58 ` Ross J. Reedstrom <reedstrm@rice.edu> 0 siblings, 0 replies; 2+ messages in thread From: Ross J. Reedstrom @ 1999-04-16 16:58 UTC (permalink / raw) To: 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@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-04-16 16:58 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-04-15 22:28 Getting started with visual query builder in pgaccess Leon Harris <leon@quoll.com> 1999-04-16 16:58 ` Ross J. Reedstrom <reedstrm@rice.edu>
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