WOW!!! I wish it was free!!!
James Mitchell Software Engineer\Struts Evangelist Struts-Atlanta, the "Open Minded Developer Network" http://www.open-tools.org/struts-atlanta > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 2:08 PM > To: [EMAIL PROTECTED] > Subject: RE: SQL Query Builder [Off Topic] > > > DBVisualizer? > > -----Original Message----- > > From: Galbreath, Mark [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, September 17, 2002 11:29 AM > > To: 'Struts Users Mailing List' > > Subject: RE: SQL Query Builder [Off Topic] > > > > > > yep - but I'd be willing to bet someone has written a Swing > > query engine. > > > > -----Original Message----- > > From: James Mitchell [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, September 17, 2002 12:10 PM > > To: Struts Users Mailing List > > Subject: RE: SQL Query Builder [Off Topic] > > > > > > Isn't that only for Oracle? > > > > I was hoping to find an Open Source Swing alternative myself. > > > > > > > > James Mitchell > > Software Engineer\Struts Evangelist > > Struts-Atlanta, the "Open Minded Developer Network" > > http://www.open-tools.org/struts-atlanta > > > > > > > > > > > -----Original Message----- > > > From: Galbreath, Mark [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, September 17, 2002 12:01 PM > > > To: 'Struts Users Mailing List' > > > Subject: RE: SQL Query Builder [Off Topic] > > > > > > > > > I use PL/SQL Developer 5.0. > > > > > > -----Original Message----- > > > From: James Mitchell [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, September 17, 2002 12:00 PM > > > To: Struts Users Mailing List > > > Subject: RE: SQL Query Builder [Off Topic] > > > > > > > > > Well, I'm pretty proficient in sql. But for extremely complex > > > queries that > > > require multiple outer joins (like more than 8 tables), I rely on > > > the visual > > > query building capabilities of Visual Interdev (ya ya ya M$ sucks). > > > > > > I'd love to hear about any open source project that can do > > what Interdev > > > does: > > > > > > It gives you 4 panes. > > > 1. Tables > > > 2. Fields selected > > > 3. Sql used > > > 4. Results of query (if you run it) > > > > > > Truly wysiwyg, drop a new table in the table pane, and all panes are > > > updated. Modify the sql pane and all the other panes are > > updated as well. > > > > > > When you connect to an ODBC source (yes, this requires > > ODBC, but the sql > > > generated works regardless) you can just drag in all the > > tables you want. > > > Add filter params and order by, do grouping, sum, count, whatever. > > > > > > This also requires that you know your database > > relationships (to a certain > > > extent). Interdev will read the metadata off the > > connection and do a best > > > guess based on > > > > > > The reason I use Interdev is that it creates the vendor specific > > > sql syntax, > > > which can be different for Oracle vs. DB2 vs. MySql > > > > > > Then I just copy from the sql pane into my application (be > > it a resource > > > file or into the code) and I'm done. > > > > > > > > > > > > James Mitchell > > > Software Engineer\Struts Evangelist > > > Struts-Atlanta, the "Open Minded Developer Network" > > > http://www.open-tools.org/struts-atlanta > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Howard Miller [mailto:[EMAIL PROTECTED]] > > > > Sent: Tuesday, September 17, 2002 11:15 AM > > > > To: '[EMAIL PROTECTED]' > > > > Subject: SQL Query Builder [Off Topic] > > > > > > > > > > > > Hi, > > > > > > > > This is completely off-topic, and I'm sorry in advance, but > > > this is where > > > > all the usefull people live!!! > > > > > > > > Has anybody come accross a SQL query builder, or even > > query-by-example > > > > builder in java. That is something to visually put > > together a query for > > > > non-sql-savy users. Its to live in a Struts application, > > so must be > > > > Servlet/JSP/Applet based. > > > > > > > > Trying to save myself some work!! > > > > > > > > Howard Miller > > > > > > > > > > > > > > > > -- > > > > To unsubscribe, e-mail: > > > > <mailto:[EMAIL PROTECTED]> > > > > For additional commands, e-mail: > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > -- > > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
