CheckSQLSyntax 

Syntax

object.CheckSQLSyntax

Description

Call this method to trigger validation of the SQL statement of the query opened within ELS-QB control.

Remarks

CheckSQLSyntax method returns True if the syntax of the SQL statement of the currently open query is successfully verified against the back-end database, otherwise it returns False.

Note: If ELS-QB component fails to check successfully SQL syntax of a statement, it will deactivate Relations and Columns panes after a corresponding message prompt indicating the syntax error.

Example

For Sample of CheckSQLSyntax usage see Sub itmCmdCheckSQLSyntax_Click() of the frmELS_QB in ELS_QBDemoVB project.