IBX.IBScript.TIBSQLParser
Delphi
TIBSQLParser = class(TComponent)
C++
class PASCALIMPLEMENTATION TIBSQLParser : public System::Classes::TComponent
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | IBX.IBScript.pas IBX.IBScript.hpp |
IBX.IBScript | IBX.IBScript |
Description
TIBSQLParser is an IBX parser for SQL commands.
The SQL script is a set of SQL commands that can contain one or more SQL statements. To execute the SQL Script on an IBX DBMS, use the TIBScript component.
TIBScript and TIBSQLParser are highly related. Use the TIBSQLParser to parse the SQL Script before executing it on the DBMS. To verify the scripting code, use the Script property of the TIBSQLParser.
You can also use TIBSQLParser to parse the insert, update, and delete InterBase SQL statements from the TIBDataSet.
Assign the script to parse to the Script property of the TIBSQLParser. To start the parsing process, call the Parse method. When a statement is successfully parsed, the statement is sent to the OnParse event handler, including the SQL statement type and the statement itself. When an error occurs when parsing a statement, the OnError event handler is called including the error and the statement itself. A parsing error means that the parsing type cannot be identified.
Use the Terminator property to specify the character used to define the end of a statement. The character by default is ";".
Use the Paused property to stop the parsing process.