Class TSQLScript (unit RxQuery)

Inherits from

TComponent

Constructors


constructor Create(AOwner: TComponent);

TSQLScript


Functions

destructor Destroy;


procedure ExecSQL;


procedure ExecStatement(StatementNo: Integer);


function ParamByName(const Value: string): TParam;


procedure CheckExecQuery(LineNo, StatementNo: Integer);


procedure ExecuteScript(StatementNo: Integer);


procedure CreateParams(List: TParams; const Value: PChar);


function GetDatabase: TDatabase;


function GetDatabaseName: string;


function GetDBSession: TSession;


function GetParamsCount: Word;


function GetSessionName: string;


function GetText: string;


procedure QueryChanged(Sender: TObject);


procedure SetDatabaseName(const Value: string);


procedure SetParamsList(Value: TParams);


procedure SetQuery(Value: TStrings);


procedure SetSessionName(const Value: string);


Properties

property AfterExec : TNotifyEvent


property BeforeExec : TNotifyEvent


property DatabaseName : string


property IgnoreParams : Boolean


property Params : TParams


property SemicolonTerm : Boolean


property SessionName : string


property SQL : TStrings


property Term : Char


property Transaction : Boolean


property Database : TDatabase


property DBSession : TSession


property ParamCount : Word


property Text : string


Events

event OnScriptError : TScriptErrorEvent


Variables

FAfterExec : TNotifyEvent;


FBeforeExec : TNotifyEvent;


FIgnoreParams : Boolean;


FOnScriptError : TScriptErrorEvent;


FParams : TParams;


FQuery : TRxQuery;


FSemicolonTerm : Boolean;


FSQL : TStrings;


FTerm : Char;


FTransaction : Boolean;



Constructors


constructor Create(AOwner: TComponent);

TSQLScript


Functions


destructor Destroy;


procedure ExecSQL;


procedure ExecStatement(StatementNo: Integer);


function ParamByName(const Value: string): TParam;


procedure CheckExecQuery(LineNo, StatementNo: Integer);


procedure ExecuteScript(StatementNo: Integer);


procedure CreateParams(List: TParams; const Value: PChar);


function GetDatabase: TDatabase;


function GetDatabaseName: string;


function GetDBSession: TSession;


function GetParamsCount: Word;


function GetSessionName: string;


function GetText: string;


procedure QueryChanged(Sender: TObject);


procedure SetDatabaseName(const Value: string);


procedure SetParamsList(Value: TParams);


procedure SetQuery(Value: TStrings);


procedure SetSessionName(const Value: string);


Properties


property AfterExec : TNotifyEvent


property BeforeExec : TNotifyEvent


property DatabaseName : string


property IgnoreParams : Boolean


property Params : TParams


property SemicolonTerm : Boolean


property SessionName : string


property SQL : TStrings


property Term : Char


property Transaction : Boolean


property Database : TDatabase


property DBSession : TSession


property ParamCount : Word


property Text : string


Events


event OnScriptError : TScriptErrorEvent


Variables


FAfterExec : TNotifyEvent;


FBeforeExec : TNotifyEvent;


FIgnoreParams : Boolean;


FOnScriptError : TScriptErrorEvent;


FParams : TParams;


FQuery : TRxQuery;


FSemicolonTerm : Boolean;


FSQL : TStrings;


FTerm : Char;


FTransaction : Boolean;