Active Query Builder 2 .NET Edition reference
BaseSQLBuilder Class Members
Properties  Methods  Events

The following tables list the members exposed by BaseSQLBuilder.

Public Properties
 NameDescription
Public PropertyAsKeywordInExpressionAliasInstructs the component to insert "AS" keyword between field name and alias ("Fleld AS Alias") or not.  
Public PropertyAsKeywordInObjectAliasInstructs the component to insert "AS" keyword between object name and its alias ("Table AS Alias") or not.  
Public PropertyCTESubQueryFormatDetermines various formatting options for Common Table Expressions.  
Public PropertyDerivedQueryFormatDetermines various formatting options for derived tables.  
Public PropertyExpandVirtualObjectsInstructs SQL Builder to expand virtual objects and fields to appropriate expressions, sub-queries and dervied tables in result SQL query text or not.  
Public PropertyExpressionSubqueryFormatDetermines various formatting options of sub-queries used in expressions.  
Public PropertyInnerKeywordInLinksInstructs the component to insert "INNER" keyword before "JOIN" clause or not.  
Public PropertyIsUpdatingIndicates that the component is in update mode now.  
Public PropertyKeywordFormatDetermines keywords format in the generated SQL query text.  
Public PropertyMainQueryFormatDetermines various formatting options for the main query.  
Public PropertyObjectPrefixSkippingInstructs the component to skip the unnecessary database object prefixes (database, schema or both) or not.  
Public PropertyOuterKeywordInLinksInstructs the component to insert "OUTER" keyword before "JOIN" clause or not.  
Public PropertyParenthesizeANDGroupsInstructs 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.  
Public PropertyParenthesizeSingleCriterionInstructs the component to enclose in parentheses single arithmetic operators for clarity of criteria representation in text form.  
Public PropertyQueryBuilderRefers to the QueryBuilder object to which SQL Builder belongs to.  
Public PropertyQuoteAllIdentifiersInstructs the component to quote all identifiers, even if its not necessary according to specific SQL syntax rules.  
Public PropertyRightMarginDefines maximum length of lines in the generated SQL query text. Zero value means unlimited length of lines.  
Public PropertySQLReturns formatted SQL query text.  
Public PropertyTargetQueryPartInstructs to generate the SQL query text not for the whole query, but for currently visible part of the query only.  
Public PropertyUseAltNamesInstructs to generate result SQL query text using alternate names or real database object and field names.  
Top
Public Methods
 NameDescription
Public MethodBeginUpdatePrevents the component from SQL generation until the EndUpdate method is called.  
Public MethodEndUpdateResumes SQL generation after it was suspended by the BeginUpdate method.  
Top
Public Events
 NameDescription
Public EventBeginBuildSQLForNodeFired when the SQL Builder starts build SQL text for a node.  
Public EventEndBuildSQLForNodeFired when the SQL Builder ends build SQL text for a node.  
Public EventSQLUpdatedFired on update of result SQL query text.  
Top
See Also

Reference

BaseSQLBuilder Class
ActiveDatabaseSoftware.ActiveQueryBuilder Namespace

 

 


© Copyright 2005-2012 ActiveDBSoft. All rights reserved.

Send Feedback