Visual Query Runtime Component

From: Tim Romano <tim_at_superstream.net>
Date: 1998/04/16
Message-ID: <3535FDC7.3156FE3@superstream.net>#1/1

I've been searching for a component that might not exist. Is there anything out there that fits the following description?

An MS-Access-like visual query component or component-suite that:
1. can be used at runtime, not just at design 2. displays tables visually in a sizeable, horizontally-scrollable region, as rectangles containing data column names

3. permits joins by drag-drop between rectangle-columns
4. represents the join visually with a linking line
5. allows edit of join properties
6. allows user to specify which columns are to be

displayed by drag-drop of columns to a display-grid region
7. gathers query conditions and aggregate functions visually
8. returns an ANSI-compliant SQL string
(but does not execute the query or have to handle database connectivity)         

   mySQL = VizQ.SQL

9. will be able to be accommodate differences in SQL syntax of an underlying RDBMS (e.g. (+) for Oracle left joins) when building the SQL string

What I'm trying to do is give end-users the ability to build queries visually with a sophisticated drag-drop interface (rather than a Wizard interface); then I will take the resultant SQL string and use it with Oracle Objects for OLE or OCI-based connectivity components and display results in a grid control.

Thanks,
Tim Received on Thu Apr 16 1998 - 00:00:00 CDT