CheckSQLSyntax
Syntax
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.