Visual Query Builder: component wish
Since the readership here might be well-placed to make a few product
I've been to ComponentOne. They don't have what I want.
What I have been wanting, for 5 years, is a component for building queries
visually --in an enterprise setting. The component would be (visually) a
knock-off of the visual query builder in Microsoft Access or Paradox, where
tables/views are represented by rectangles containing column names, and you
drag a table onto the query pallette to work with it, and where joins are
represented by connecting lines, and join-charactertics can be edited by
double-clicking on the line. See Access for details. BUT,
I want this component to work in UNBOUND mode. I want to be able to handle
all database I/O myself. UNBOUND mode is actually more important than bound
mode for its target audience of enterprise developers. This component does
not have to make any connection to a database!!!! It does not have to know
how to write to the database or concern itself with permissions. I want to
be able to explicitly specify the tables and columns that the users may see,
and establish the primary key/foreign key relationships, and the datatypes,
I want to be able to specify the joins and put the component optionally into
auto-join mode, at run-time.
I want the component to return the SQL command to me, NOT AS A STRING, but
as a read-write hierarchical SQL **object**.
I want to be able to modify any of the WhereConditions or substitute a
different table in the Tables collection (making appropriate changes to the
items in the Joins collection) and then get a reformulated SQL command
myCommand$ = oSQL.ToString
Additional intelligence: the component should be able to identify [maybe
in version 2 ;-) ] whether the SQL command would produce a cartesian
product, or whether two joined columns are of a different datatype. In
version 1, the oSQL object has to be constructed so that I can easily
iterate the collection classes and determine such things for myself.
I must be able to examine the Joins collection, see which columns are joined
to which, and find out the datatypes of the columns. I should be able to see
which tables are involved in the query and whether any of them is not joined
to another table.
The component should be able to produce valid SQL command strings for
various target databases (SQLServer and Oracle for starters); the database
should be changeable at run-time:
oSQL.TargetDatabase = VQB_Targets.VQB_ORACLE
Such a product, if done well, would be a very successful app in the
enterprise space, IMO. What would I be willing to pay for such a component?
~$599 for a single seat with royalty-free deployment. $2500 for a
Re: Visual Query Builder: component wish
On Mon, 18 Jun 2001 13:43:09 -0400, "Tim Romano" <firstname.lastname@example.org
(REVERSE IT)> wrote:
>I want this component to work in UNBOUND mode.
Not quite sure what you mean here. I use bound and unbound recordsets
in VB all the time. In (nearly) all cases, whether using SQL Server,
AS/400, or Access, I've been using the QBE features in Access to
build a query without saving it, then cutting and pasting the SQL into
my apps. Sometimes the query needs minor hand-tuning (e.g. for ADO,
replacing * with % in Like and so on). Then I chuck the (sometimes
disconnected) rs at a grid, which nowadays is always a VideoSoft OleDb
Flex Grid, having been through FarPoint, TrueGrid, all the in-built
grids, and Some Other Grids.
Did you have a really good scour of the internet for such a tool?
Re: Visual Query Builder: component wish
By "unbound" I mean the developer is responsible for all database i/o and
for populating the control. I'm not interested in the SQL command STRING
primarily; I want the SQL command to be parsed and presented as a
hierarchical object. Cut-paste is not an option.
"Mike Mitchell" <email@example.com> wrote in message
> On Mon, 18 Jun 2001 13:43:09 -0400, "Tim Romano" <firstname.lastname@example.org
> (REVERSE IT)> wrote:
> >I want this component to work in UNBOUND mode.
> Not quite sure what you mean here. I use bound and unbound recordsets
> in VB all the time. In (nearly) all cases, whether using SQL Server,
> AS/400, or Access, I've been using the QBE features in Access to
> build a query without saving it, then cutting and pasting the SQL into
> my apps. Sometimes the query needs minor hand-tuning (e.g. for ADO,
> replacing * with % in Like and so on). Then I chuck the (sometimes
> disconnected) rs at a grid, which nowadays is always a VideoSoft OleDb
> Flex Grid, having been through FarPoint, TrueGrid, all the in-built
> grids, and Some Other Grids.
> Did you have a really good scour of the internet for such a tool?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL