Skip site navigation (1) Skip section navigation (2)

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
Message-ID: (view raw, whole thread or download thread 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

pgsql-interfaces by date

Next:From: Yu CaoDate: 1999-04-17 03:03:00
Subject: TBLOCK status from libpq / libpq++
Previous:From: Pavel PaJaSoft JanousekDate: 1999-04-16 10:03:09
Subject: Selecting more columns in ECPG in one select - error?

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group