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
	See Flash Demo ELS-QB ActiveX FAQ ELS-QB On-line Help Download ELS-QB User's Guide Download Query Builder Application that hosts ELS-QB
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]