TSQLScript class

Declaration

Inheritance

1. TSQLScript
2. TCustomSQLscript

Description

TSQLScript is a component that can be used to execute many SQL statements using a TSQLQuery component. The SQL statements are specified in a script Script separated by a terminator character (typically a semicolon (;)).

See also

• TSQLTransaction
• TSQLConnection
• ExecSQL
• SQL

Properties

Aborted	public	True when the script was aborted.
Line	public	Current line of execution in the script.
DataBase	published	Database on which to execute the script.
Transaction	published	Transaction to use in the script.
AutoCommit	published	Automatically commit every statement.
UseDollarString	published	Enable support for dollarstrings.
DollarStrings	published	List of alternate string delimiter token sequences.
Directives	published	List of directives.
Defines	published	Defined macros.
Script	published	The script to execute.
Terminator	published	Terminator character.
CommentsinSQL	published	Should comments be passed to the SQL engine ?
UseSetTerm	published	Should the SET TERM directive be recognized.
UseCommit	published	Control automatic handling of the COMMIT command.
UseDefines	published	Automatically handle pre-processor defines.

Methods

ExecuteStatement	protected
ExecuteDirective	protected
ExecuteCommit	protected
SetDatabase	protected
SetTransaction	protected
CheckDatabase	protected
CreateQuery	protected
Create	public	Create a new TSQLScript instance.
Destroy	public	Remove the TSQLScript instance from memory.
Execute	public	Execute the script.
ExecuteScript	public	Convenience function, simply calls Execute.

Events

OnDirective	published	Event handler if a directive is encountered.
OnException	published	Exception handling event.