Home | Services | Products | Support | Company Info

Epsilon-Logic Systems' Query Builder 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 (see snapshot at the bottom of this page or see Flash demo).
Full Product - Only $299
30-days money back guarantee
 
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
  • MS-Access style query building visual interface
  • Run-time multiple database connection manager with built-in storage support
  • Data browser pane integrated with the Connection 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, MySQL, and all ODBC complaint 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
  • Call function to export the query result in HTML formatted output
  • API functions to export the query result directly in Delimited/Fixed Text, CSV (for Excel), dBASE III and XML file formats
  • Edit tables directly via the query result in the Result tab's grid
  • Royalty free run-times and sample application distribution

New Features Include:
  • Extended the query builder interface to handle all kinds of queries including SELECT, INSERT, INSERT VALUES, UPDATE, DELETE and Make Table queries
  • Added new API function NewQueryX to create such query types programmatically
  • Added new API function ShowDBObjectsX to restrict the visibility of database objects in the DB Browser based on object category and prefix/suffix pattern of the name of the object
  • Integrated ADO data-bound grid to enhance the performance of the query result display
  • Enhanced direct edit feature and Find/Replace operations on the query result in the Result grid
  • Added API functions ShowErrorMessage, GetErrorMessage and ClearErrorMessage for custom error message handling in the host
  • Enhanced the query builder GUI to have Office XP menu and toolbar look
  • Added VB.NET, C# and VC.NET sample application along with the extended VB6 and VC6 samples
  • Updated and extended the documentation
  • Resolved all previously reported bugs


[Home] | [Services] | [Products] | [Support] | [Company Info]

Send mail to Webmaster with questions or comments about this web site.
Copyright 1998-2004 Epsilon-Logic Systems