HomeActive Query Builder - IntroductionCommon QuestionsWhat is the Sleep mode and how it helps to deal with unsupported SQL statements?

3.4. What is the Sleep mode and how it helps to deal with unsupported SQL statements?

The Sleep mode is made to allow the end-users to write SQL statements that are not supported by Active Query Builder (DML, DDL) in the text editor.

This mode is enabled by default, but might be disabled by setting the QueryBuilder.AllowSleepMode property to False. Switching to this mode is done automatically on assigning a not supported SQL query to the query builder. During this assignment no parsing exceptions are thrown, but the QueryBuilder.SleepModeChanged event is fired.

Being in the Sleep Mode the component shows empty diagram pane and query columns grid. It may be activated by assigning the SELECT SQL statement to it or by starting to build a new query visually. On starting to build a new query visually being in the sleep mode, the QueryBuilder.QueryAwake event is fired. By handling this event you may ensure that the user really wants to start build a new query (this action will replace the previous non-supported SQL statement with a new one) and allow or deny switching to the normal mode.

This page was: Helpful | Not Helpful