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