TIB_Script Class

Declaration
TIB_Script = class(TIB_Process)

Description
This component allows multiple consecutive DML, DDL, etc. statements to be executed sequentially.

This is very useful for creating database files or for performing batch updates.

During the process of execution if the API returns an error code the OnError event gives an opportunity to override or handle it and determine if execution of the Script should continue or not. To examine the statement that caused the error check the CurrentSQL property.

It is also possible to provide custom handling per each individual statement that will be processed. Use the OnStatement event for this.

Introduced Public Properties

CurrentSQL The individual statement that is currently being sent to the API.

IB_Connection Connection for which this script will be executed.

IB_Transaction Transaction for which the script will be executed in.

SetItem When parsing through a script there are various SET statements that are valid ISQL syntax.

SetValue When parsing through a script there are various SET statements that are valid ISQL syntax.

SQL Stores the statements to be executed.

Introduced Public Events

OnStatement This event allows a little bit more control over how statements are executed by the script.

CurrentSQL	The individual statement that is currently being sent to the API.
IB_Connection	Connection for which this script will be executed.
IB_Transaction	Transaction for which the script will be executed in.
SetItem	When parsing through a script there are various SET statements that are valid ISQL syntax.
SetValue	When parsing through a script there are various SET statements that are valid ISQL syntax.
SQL	Stores the statements to be executed.