HomeActive Query Builder - IntroductionCommon QuestionsHow to setup SQL text formatter?

3.1. How to setup SQL text formatter?

To get the formatted SQL text, you should add the PlainTextSQLBuilder object and assign a QueryBuilder object to the PlainTextSQLBuilder.QueryBuilder property. After that you can handle the SQLUpdated event to get the formatted SQL text. The links below point to the lists of available properties to setup the formatting:

PlainTextSQLBuilder inherits BaseSQLBuilder which has separate sets of properties for Main query, expression sub-queries, derived tables and Common Table Expressions.

A set of formatting options for a single query is reprtesented by the SQLBuilderSelectFormat class.

This page was: Helpful | Not Helpful