Re: [INTERFACES] Getting started with visual query builder in pgaccess

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
Views: Raw Message | Whole Thread | Download mbox
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

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 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

In response to

Browse pgsql-interfaces by date

  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?