ActiveDatabaseSoftware.ActiveQueryBuilder Namespace : QueryBuilder Class |
The following tables list the members exposed by QueryBuilder.
Name | Description | |
---|---|---|
![]() | QueryBuilder Constructor | Overloaded. Initializes a new instance of the QueryBuilder component. |
Name | Description | |
---|---|---|
![]() | ActiveSubQuery | Provides access to the currently visible to end-user sub-query. |
![]() | AddObjectFormOptions | Determines appearance of the Add Object Form. |
![]() | BehaviorOptions | Allows you to tune the way Active Query Builder parses and builds SQL queries. |
![]() | DatabaseSchemaTree | Returns an interface to the Database Schema Tree View control. |
![]() | DatabaseSchemaTreeOptions | Contains various properties of the Database Schema Tree control. |
![]() | DataSourceOptions | Contains various properties of the Design Pane. |
![]() ![]() | DefaultImageList | Gets the list of default icons. |
![]() | DesignPaneOptions | Determines appearance of the objects within the Design Pane. |
![]() | ExpressionEditor | Gets or sets a reference to the Expression Editor interface that allows to edit SQL expressions and criteria in a multi-line text editor with code auto-completion and syntax highlight. |
![]() | IsUpdating | Indicates that the component is in update mode now. |
![]() | Language | Gets or sets the language. |
![]() | LayoutSQL | Gets or sets the SQL query text among with layout, i.e. sizes and positions of objects within the Design Pane in XML format. |
![]() | MetadataContainer | Returns a reference to the Metadata Container, an object to hold information about database schema, database objects and their attributes. |
![]() | MetadataLoadingOptions | Determines rules of loading database schema information to the Metadata Container. |
![]() | MetadataProvider | Gets or sets a reference to the Metadata Provider object used to retrieve metadata from a database or from another source. |
![]() | MetadataStructure | Gets or sets the reference to the Metadata Structure object that represents the content of Metadata Container in a tree-like form. |
![]() | MetadataStructureOptions | Contains various properties that affect on displaying of the Metadata Structure. |
![]() | OfflineMode | Allows to switch the component between normal and "Offline" modes. |
![]() ![]() | OverrideDevExpressThemeColors | Gets or sets a value indicating whether to override DevExpress controls theme colors. |
![]() | PanesConfigurationOptions | Allows you to configure layout of the main parts of the component: Design Pane, Query Columns List, Database Schema Tree and Query Structure Tree. |
![]() | Parameters | Allows to retrieve information about parameters that were used in the query. |
![]() | Query | Provides access to the main Query object. |
![]() | QueryColumnListOptions | Contains various properties of the Query Column List control. |
![]() | QueryStatistics | Allows to retrieve various information about the query: list of used database objects and their fields, list of output query columns. |
![]() | QueryStructureTree | Returns an interface to the Query Structure Tree View control. |
![]() | QueryStructureTreeOptions | Contains various properties of the Query Structure Tree. |
![]() | ResultQueryAST | Gets the abstract sytnax tree of result SQL query. |
![]() | RightToLeftLayout | Gets or sets a value indicating whether right-to-left mirror placement is turned on. |
![]() | SleepMode | Indicates that the component is in the "Sleep" Mode. |
![]() | SQL | Use this property to get or set SQL query text in response to user actions. |
![]() | SQLChanging | Indicates that the process of updating the query is running now. |
![]() | SQLContext | Determines context of the query building, parsing and SQL generation processes. |
![]() | SQLGenerationOptions | Determines SQL query text generation rules for the QueryBuilder.SQL property. |
![]() | SubQueries | Lists all sub-queries in the query. |
![]() | SyntaxProvider | Gets or sets a reference to the Syntax Provider object used to define SQL syntax rules of specific database servers. |
![]() | Tabs | Returns an interface to the Sub-Query Tab control. |
![]() ![]() | UseDevExpressControls | Allows to switch component's visual controls from standard .NET controls to DevExpress WinForms controls. |
![]() | VisualOptions | Contains visual options that are not related to any pane. |
Name | Description | |
---|---|---|
![]() | BeginUpdate | Prevents the component from SQL generation until the EndUpdate method is called. |
![]() | Clear | Clears the query. |
![]() | ClearSearchBox | Clears the text in Database Schema Tree search box. |
![]() | ClearSearchResults | Clears search results in the Database Schema Tree and restores the original metadata structure. |
![]() ![]() | EditMetadataContainer | Overloaded. Shows the Metadata Editor form to edit content of the Metadata Container. |
![]() ![]() | EditMetadataContainerStandalone | Overloaded. Shows the Metadata Editor form with the content of given MetadataContainer object in the Standalone mode, i.e. as a standalone application. |
![]() | EndUpdate | Resumes SQL generation after it was suspended by the BeginUpdate method. |
![]() | GetSubQueryList | Returns list of all sub-queries in the query. |
![]() | GetUnionSubQueryList | Returns list of all union sub-queries in the query. |
![]() | InitializeDatabaseSchemaTree | Initializes the database schema tree. |
![]() | IsSearching | Indicates the search for database objects is in progress. |
![]() | PaintDesignPaneToBitmap | Gets bitmap of the Design Pane. |
![]() | RefreshDatasourcesMetadata | Refreshes the list of fields for datasources of the current query. |
![]() ![]() | ShowAboutDialog | Shows the About dialog window. |
![]() | ShowAddObjectForm | Shows the Add Object Form. |
![]() ![]() | ShowMetadataContainerLoadWizard | Displays the Metadata Container load wizard. |
![]() | ShowQueryBuilderPropertiesForm | Displays the dialog that allows to set various properties of the Query Builder and the SQL Builder components visually. |
![]() | StopSearch | Stops searching for database objects. |
Name | Description | |
---|---|---|
![]() | ActiveSubQueryChanged | Invoked when currently visible sub-query is changed. |
![]() | ActiveUnionSubQueryChanged | Invoked when currently visible union sub-query is changed. |
![]() | AfterPropertiesDialog | Invoked after any of the properties dialogs (Sub-query, DataSource, Link properties) are closed. |
![]() | BeforeDatasourceFieldDrag | Invoked when the user starts to drag a DataSource Field at the Design Area. |
![]() | BeforePropertiesDialog | Invoked before any of the properties dialogs (Sub-query, DataSource, Link properties) is shown. |
![]() | ControlCreated | Invoked when a control is created inside the component. |
![]() | ControlDestroying | Invoked before the control is destroyed inside the component. |
![]() | CustomExpressionBuilder | Is called to edit SQL expression of the Expression or Criteria column cell of the Query Columns Grid when the user clicks the ellipsis button. |
![]() | CustomizeDatasourceCaption | Is called to customize the caption of a DataSource at the Design Area. |
![]() | CustomizeDatasourceFieldList | Is called to customize the field list of a DataSource at the Design Area. |
![]() | DataSourceAdded | Invoked when DataSource is added by the user. |
![]() | DataSourceAdding | Invoked when DataSource is about to be added by the user. |
![]() | DataSourceDeleting | Invoked when DataSource is about to be deleted by the user. |
![]() | DatasourceFieldAdded | Invoked when Field is added to the query by checking it at the DataSource field list. |
![]() | DatasourceFieldAdding | Invoked when Field is about to be added to the query by checking it at the DataSource field list. |
![]() | DatasourceFieldRemoved | Invoked when Field is removed from the query by unchecking it at the DataSource field list. |
![]() | DatasourceFieldRemoving | Invoked when Field is about to be deleted from the query by unchecking it at the DataSource field list. |
![]() | DesignPaneLayoutChanged | Fired when layout of objects on the design pane is changed. |
![]() | Destroying | Occurs before the component is destroyed. |
![]() | FieldListDrawItem | Called to draw an item of the DataSource Field List. |
![]() | FocusedDesignPaneControlChanged | Occurs when a focused object at the Design Pane is changed. |
![]() | GetDatabaseSchemaTreeToolTipText | Fired to request the tooltip text for objects in the Database Schema Tree. |
![]() | GetDataSourceFieldToolTipText | Fired to request the tooltip text for fields in the Datasource field list. |
![]() | GetDiagramObjectWidth | Called to calculate width of the newly added datasource. |
![]() | GetProcedureParameters | Fired when the component requests parameter values for stored procedure or function. |
![]() | GridCellValueChanged | Invoked when one of the Query Columns Grid Control cells is changed by the user. |
![]() | GridCellValueChanging | Invoked when one of the Query Columns Grid Control cells is about to be changed by the user. |
![]() | LanguageChanged | Fired on changing the Language property. |
![]() | LinkChanged | Invoked when the Link properties are changed by the user. |
![]() | LinkChanging | Invoked when the Link properties are about to be changed by the user. |
![]() | LinkCreated | Invoked when the link between datasources is created by the user. |
![]() | LinkCreating | Invoked when the link between two datasources is about to be created by the user. |
![]() | LinkDeleting | Invoked when the link between datasources is about to be deleted by the user. |
![]() | LinkDragOver | Invoked when the user drags a DataSource Field over the other DataSource Field to create a link between these fields. |
![]() | QueryAwake | Occurs when the component is currently in the "Sleep" mode and the user starts to build a query visually. |
![]() | SleepModeChanged | Invoked when the component is turns the "Sleep" mode on and off. |
![]() | SqlError | Invoked on SQL text parsing error. |
![]() | SQLUpdated | Occurs each time the component updates the output SQL query text. |
![]() | UserMessage | Fired when the component is about to show the warning message to the user. |
![]() | ValidateContextMenu | Is called before any of the component's context menus is shown. |