Relyea, Mike wrote:
> I use Access as my front end, and had the same problem. In the end I
> ended up using pass-thru queries that I created on the fly with a little
> VBA. I still use the query builder in Access to get all of my joins
> right (it's so much easier to see it visually when there are a lot of
> joins). I bring the SQL that Access generates into Notepad and hand
> massage it until I've got it just right.
For this hand massaging job I'd recommend pgAdmin's query tool: you have
syntax highlighting and can check syntax and performance immediately.
We still don't have a programmer who's interested in spending time on a
query builder for pgAdmin, volunteers are welcome.
In response to
pgsql-odbc by date
|Next:||From: Dianne Yumul||Date: 2006-02-24 17:34:52|
|Subject: Compile error on Mac OS X|
|Previous:||From: Goulet, Dick||Date: 2006-02-23 23:56:57|
|Subject: Re: Access as a front-end or another query builder|