TSQLScript

type TSQLScript = class(TCustomSQLscript)

public

  constructor Create(); override;

Create a new TSQLScript instance.

  destructor Destroy; override;

Remove the TSQLScript instance from memory.

  procedure Execute; override;

Execute the script.

  procedure ExecuteScript;

Convenience function, simply calls Execute

published

  property DataBase: TDatabase; [rw]

Database on which to execute the script

  property Transaction: TDBTransaction; [rw]

Transaction to use in the script

  property OnDirective: TSQLScriptDirectiveEvent; [rw]

Event handler if a directive is encountered

  property UseDollarString;

Enable support for dollarstrings

  property DollarStrings;

List of alternate string delimiter token sequences

  property Directives;

List of directives

  property Defines;

Defined macros

  property Script;

The script to execute

  property Terminator;

Terminator character.

  property CommentsinSQL;

Should comments be passed to the SQL engine ?

  property UseSetTerm;

Should the SET TERM directive be recognized

  property UseCommit;

Control automatic handling of the COMMIT command.

  property UseDefines;

Automatically handle pre-processor defines

  property OnException;

Exception handling event

end;

TSQLScript

Component to execute various SQL statements

TCustomSQLscript

TObject

TSQLTransaction

Transaction in which a TSQLQuery is handled

TSQLConnection

An abstract class representing a connection to a SQL Database

TCustomSQLQuery.ExecSQL

Execute a SQL statement that does not return a result set

TSQLQuery.SQL

The SQL statement to execute