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. |