HomeActive Query BuilderHow to change the settings programmatically

How to change the settings programmatically


Colleagues,

I want to insert a line after the SELECT statement, how to Finning settings programmatically?

Thank
Bene
Benedito Santana | email
October 1 2009, 02:33 PM
Do you want to insert an empty line or a line with some SQL clauses?

Can you show an example of SQL statement before and after modification?
Sergey Smagin | email
7 hours, 7 mins since original post
Hello Sergey Smagin,

I studied the examples after buying the QueryBuilder, I'm interested in changing the properties of the SQL Builder Options

Changing Insert new line after keyword part programmatically?

Changing Insert new line after each select list item programmatically?

Before:

select * from customers

After

SELECT
*
FROM
Customers

Thanks
Bene
Benedito Santana | email
16 hours, 57 mins since original post
Use the PlainTextSQLBuilder.MainQueryFormat.NewLineAfterPartKeywords, plainTextSQLBuilder1.MainQueryFormat.SelectListFormat.NewLineAfterItem properties. Also please refer to the same properties in PlainTextSQLBuilder.DerivedQueryFormat and PlainTextSQLBuilder.ExpressionSubqueryFormat groups.
Sergey Smagin | email
4 days, 12 hours since original post
This topic is closed