Обсуждение: 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