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