Mmm... I actually just need to build the "where" clause part. But I need to give my users only the possible fields and values that are available, yet let them have the opportunity in construction fairly complex filters with multiple AND and OR and parenthesis.
A general expression builder might do it with some modification. Howard On 17 Sep 2002 at 12:29, Galbreath, Mark wrote: > 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]>
