The following tables list the members exposed by BaseSQLBuilder.
Public Properties
| Name | Description | |
|---|---|---|
 | AsKeywordInExpressionAlias | Instructs the component to insert "AS" keyword between field name and alias ("Fleld AS Alias") or not. |
| AsKeywordInObjectAlias | Instructs the component to insert "AS" keyword between object name and its alias ("Table AS Alias") or not. |
| CTESubQueryFormat | Determines various formatting options for Common Table Expressions. |
| DerivedQueryFormat | Determines various formatting options for derived tables. |
| ExpandVirtualObjects | Instructs SQL Builder to expand virtual objects and fields to appropriate expressions, sub-queries and dervied tables in result SQL query text or not. |
| ExpressionSubqueryFormat | Determines various formatting options of sub-queries used in expressions. |
| InnerKeywordInLinks | Instructs the component to insert "INNER" keyword before "JOIN" clause or not. |
| IsUpdating | Indicates that the component is in update mode now. |
| KeywordFormat | Determines keywords format in the generated SQL query text. |
| MainQueryFormat | Determines various formatting options for the main query. |
| ObjectPrefixSkipping | Instructs the component to skip the unnecessary database object prefixes (database, schema or both) or not. |
| OuterKeywordInLinks | Instructs the component to insert "OUTER" keyword before "JOIN" clause or not. |
| ParenthesizeANDGroups | Instructs the component to enclose in parentheses criteria groups joined with AND operator if they are separated by the OR operator for clarity of criteria representation in text form. |
| ParenthesizeSingleCriterion | Instructs the component to enclose in parentheses single arithmetic operators for clarity of criteria representation in text form. |
| QueryBuilder | Refers to the QueryBuilder object to which SQL Builder belongs to. |
| QuoteAllIdentifiers | Instructs the component to quote all identifiers, even if its not necessary according to specific SQL syntax rules. |
| RightMargin | Defines maximum length of lines in the generated SQL query text. Zero value means unlimited length of lines. |
| SQL | Returns formatted SQL query text. |
| TargetQueryPart | Instructs to generate the SQL query text not for the whole query, but for currently visible part of the query only. |
| UseAltNames | Instructs to generate result SQL query text using alternate names or real database object and field names. |
Public Methods
| Name | Description | |
|---|---|---|
 | BeginUpdate | Prevents the component from SQL generation until the EndUpdate method is called. |
| EndUpdate | Resumes SQL generation after it was suspended by the BeginUpdate method. |
Public Events
| Name | Description | |
|---|---|---|
 | BeginBuildSQLForNode | Fired when the SQL Builder starts build SQL text for a node. |
| EndBuildSQLForNode | Fired when the SQL Builder ends build SQL text for a node. |
| SQLUpdated | Fired on update of result SQL query text. |
See Also