EndBuildSQLForNode Event

Active Query Builder 2 .NET Edition reference

Example Collapse All Language Filter: All

Visual Basic (Declaration)
Visual Basic (Usage)
C#
Managed Extensions for C++

ActiveDatabaseSoftware.ActiveQueryBuilder Namespace > BaseSQLBuilder Class : EndBuildSQLForNode Event

Fired when the SQL Builder ends build SQL text for a node.

Syntax

Visual Basic
C#
Managed Extensions for C++

'Declaration
 
Public Event EndBuildSQLForNode As BuildSQLForNodeEventHandler

'Usage
 
Dim instance As BaseSQLBuilder
Dim handler As BuildSQLForNodeEventHandler
 
AddHandler instance.EndBuildSQLForNode, handler

public event BuildSQLForNodeEventHandler EndBuildSQLForNode

public: __event BuildSQLForNodeEventHandler* EndBuildSQLForNode

Remarks

Used to implement custom SQL formatting rules.

Example

Adds closing parenthesis after each function in the SQL text.

private void plainTextSQLBuilder_EndBuildSQLForNode(object sender, AstNode node)
{
    if (node is SQLExpressionFunction || node is SQLExpressionAggregate)
    {
        plainTextSQLBuilder.SQLBuilder.WriteSymbol(")");
    }
}

Reference

BaseSQLBuilder Class
BaseSQLBuilder Members

Send Feedback