Active Query Builder 2 .NET Edition reference
QueryBuilder Class
Members 



QueryBuilder is the component to build SQL queries visually, to parse, analyze and modify SQL queries programmatically.
Object Model
QueryBuilder ClassAddObjectFormOptions ClassBehaviorOptions ClassDatabaseSchemaTreeOptions ClassDataSourceOptions ClassDesignPaneOptions ClassMetadataContainer ClassMetadataLoadingOptions ClassBaseMetadataProvider ClassMetadataStructure ClassMetadataStructureOptions ClassPanesConfigurationOptions ClassParameterList ClassParameter ClassQueryColumnListOptions ClassQueryStatistics ClassQueryStructureTreeOptions ClassBaseSQLContext ClassSQLGenerationOptions ClassBaseSyntaxProvider ClassVisualOptions Class
Syntax
'Declaration
 
Public Class QueryBuilder 
   Inherits System.Windows.Forms.UserControl
'Usage
 
Dim instance As QueryBuilder
public class QueryBuilder : System.Windows.Forms.UserControl 
public __gc class QueryBuilder : public System.Windows.Forms.UserControl 
Remarks

QueryBuilder requires a Syntax Provider to be assigned to the QueryBuilder.SyntaxProvider property. Metadata Provider assigned to the QueryBuilder.MetadataProvider property is necessary to load database schema information from database. Alternate way to load database schema is to use pre-generated XML files. See the MetadataContainer.ImportFromXML method for details. After that the InitializeDatabaseSchemaTree method should be called.

To get the result SQL query string, use the QueryBuilder.SQL property. Use the PlainTextSQLBuilder component to get the formatted SQL query text.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Windows.Forms.Control
            System.Windows.Forms.ScrollableControl
               System.Windows.Forms.ContainerControl
                  System.Windows.Forms.UserControl
                     ActiveDatabaseSoftware.ActiveQueryBuilder.QueryBuilder

See Also

Reference

QueryBuilder Members
ActiveDatabaseSoftware.ActiveQueryBuilder Namespace

 

 


© Copyright 2005-2012 ActiveDBSoft. All rights reserved.

Send Feedback