Software Directory
Our Network
Top Download Titles
|
|
|
|
BinaryWorX QueryBuilder
|
Generate SQL Queries from your application. BinaryWorX QueryBuilder is an ActiveX component, which allows you, as a developer, to add query designer features to your applications. This is very useful when proper adhoc query functionality is required in applications. No more forms with limited query capabilities. Give your end users the ability to get the data theyre looking for, without you having to write custom queries. This does not mean that you cant limit them on what they can or cant see. QueryBuilder exposes a number of objects and properties, which you can manipulate to hide certain tables and fields from the end-user.
Whats new in BinaryWorX QueryBuilder 2.1
Improved SQL Parser
Predictive Text when typing SQL statements in the SQLPane
Support for SELECT TOP x queries
Support for SELECT DISTINCT queries
Improved grid navigation
Memory leak problem solved
A few bugs fixed from previous versions
Features include:
A visual interface for query designing
Creating joins with drag and drop
A GridPane to specify detailed criteria, such as field conditions, field sort orders, etc
Automatic field formatting
Localization: You can specify your own text for labels in QueryBuilder, which allows you to cater for any language
SQL Parsing: QueryBuilder can parse an SQL statement, which means you can enter the SQL statement, and the DiagramPane and GridPane will be populated accordingly
Predictive Text: When using the SQLPane to enter an SQL statement, QueryBuilder will popup a list (intellilist), which makes it easier and faster to enter SQL statements
Details:
QueryBuilder consists of 4 components, which are used in conjunction with each other to create a query designer interface. The 4 components are:
DiagramPane Control - A visual component which contains Entities (tables). These Entities contain EntityItems (fields), which can be checked/unchecked to be included/excluded from an SQL statement. Relationships (joins) between Entities are also created in the DiagramPane. QueryBuilder will automatically create joins based on existing database relationships. Manual relationships can be created by dragging fields onto each other.
GridPane Control - The GridPane is the component where detailed criteria per field can be specified. You can specify field conditions, field sort orders, aggregated functions, etc.
SQLPane Control - The SQLPane component represents the SQL statement that is being defined by the DiagramPane and the GridPane. SQL statements can also be entered in the SQLPane, which can then be parsed to populate the DiagramPane and GridPane accordingly.
QueryBuilder Control - The QueryBuilder control is a non-visual component that synchronizes the DiagramPane, GridPane and SQLPane.
|
|
|
|
