BeginBuildSQLForNode 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 : BeginBuildSQLForNode Event

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

Syntax

Visual Basic
C#
Managed Extensions for C++

'Declaration
 
Public Event BeginBuildSQLForNode As BuildSQLForNodeEventHandler

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

public event BuildSQLForNodeEventHandler BeginBuildSQLForNode

public: __event BuildSQLForNodeEventHandler* BeginBuildSQLForNode

Remarks

Used to implement custom SQL formatting rules.

Example

Adds opening parentesis before each function in the SQL text.

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

Reference

BaseSQLBuilder Class
BaseSQLBuilder Members

Send Feedback