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