"FrozenDude" <ds*****@inco.comwrote
Does anyone know of or have a favourite 3rd party
Visual Query Builder? We are looking for a very
easy to use interface that provides SQL code verifi-
cation, table joins etc.
What "flavor" of SQL? Everybody's got their own little nuances.
For Access, the Access Query Builder is peachy keen.
For Microsoft SQL Server, there's a very nice Enterprise Manager.
Several years ago, I did some work with Informix and don't recall that it
included a Visual Query Builder, nor that the prime contractor on that
project licensed a third-party one. The DBA, perhaps a little grudgingly,
allowed me to create some Views to force server-side processing on some
modestly complex queries for reports, and that was an exercise in "SQL
Masochism" because I just had to sit there with nothing but the equivalent
of notepad and my bare brain and write SQL _from scratch_.
He used a third-party data modeling system, ERWIN, to design, redesign, and
implement the tables and relationships -- I don't remember what it cost,
exactly, but I do remember it was NOT "cheap". There are quite a number of
others, too, and, from my observation, all are expensive, but even so, there
are tiers of pricing... ranging from "just plain expensive" to
"flabbergastingly outrageously expensive." But that isn't what you are
asking about, I think.
Larry Linson
Microsoft Access MVP