Introduction to
ELS-QB ActiveX component
ELS-QB ActiveX is a query
builder component which gives your end-users the ability to create complex
queries via intuitive visual interface.
The interface is more advanced than MS-Access, SQL Server or other
similar query construction interfaces. The component may be integrated
with Visual Basic or Visual C++ application with just few lines of code.
In Visual Basic you may use this control via drag-drop into a form and
sizing the control and setting a few design-time properties.
Main features include the
following:
- MS-Access style query building visual
interface,
- Run-time multiple database connection
manager with built-in storage support,
-
Data browser pane integrated with the
Connections and other panes,
- View
database object information or script in
the Data Browser pane,
- Construct joins via simple drag-drop
method using the
Relations
pane,
- MS-Access style group, sort, and
criteria construction via the
Columns
pane,
- Columns toolbar combo-buttons
comprising all the SQL functions including data conversion, date,
aggregate, rounding, masking and other functions,
- Supports all database type including
MS-Access, SQL Server, Oracle, DB2, Sybase and all ODBC compliant OLE DB
providers,
- Built-in file processing and file
storage support for the manipulation of queries,
- Syntax colored SQL editor with advance
editing features similar to the Visual C++ editor,
- Sophisticated SQL parser that will
translate any valid SQL statement into the visual
Relations
and
Columns
panes,
- Show / Hide toggle buttons to maximize desired
pane view,
- Integrate with your application by
setting a few properties or a few lines of code,
- Complete editing and file processing
external control over the ActiveX component,
- Call functions for exporting and
printing the content of the
SQL
pane and query results,
- Export
query result in HTML and e-mail formats,
-
Edit query directly from the result grid,
-
Royalty free run-times,
- Package includes source code of
sample applications,
The
Office-QB
application is a good example of how the ELS-QB ActiveX component may be
utilized.
For more information about the ELS-QB ActiveX
component please visit the following URL:
http://www.epsilon-logic.net/ELSQBDetails79.asp