Class TQBEQuery (unit DBQBE)

Inherits from

TDBDataSet

TQBEQuery

Constructors


constructor Create(AOwner: TComponent);

TQBEQuery


Functions

destructor Destroy;


procedure ExecQBE;


function GetQBEText: PChar;

Retry

function IsEmpty: Boolean;


function ParamByName(const Value: string): TParam;


procedure Prepare;


procedure RefreshQuery;


procedure UnPrepare;


function CreateHandle: HDBICur;


procedure Disconnect;


function GetParamsCount: Word;


procedure SetDBFlag(Flag: Integer; Value: Boolean);


function CreateCursor(GenHandle: Boolean): HDBICur;


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


procedure FreeStatement;


function GetQueryCursor(GenHandle: Boolean): HDBICur;


function GetRowsAffected: Integer;


procedure GetStatementHandle(QBEText: PChar);


procedure PrepareQBE(Value: PChar);


procedure QueryChanged(Sender: TObject);


procedure ReplaceParams(QBEText: TStrings);


procedure SetParamsList(Value: TParams);


procedure SetPrepare(Value: Boolean);

ignore exceptions

procedure SetPrepared(Value: Boolean);

special QBE operator

procedure SetQuery(Value: TStrings);


procedure SetStartParam(Value: Char);


Properties

property AuxiliaryTables : Boolean


property BlankAsZero : Boolean

Ensure QBE is declared before Params

property ParamCheck : Boolean


property Params : TParams


property QBE : TStrings

Ensure StartParam is declared before QBE

property RequestLive : Boolean


property StartParam : Char


property UpdateMode :


property UpdateObject :


property Local : Boolean


property ParamCount : Word


property Prepared : Boolean


property RowsAffected : Integer


property StmtHandle : HDBIStmt


property Text : string


Events

Variables

FAuxiliaryTables : Boolean;


FBlankAsZero : Boolean;


FLocal : Boolean;


FParamCheck : Boolean;


FParams : TParams;


FPrepared : Boolean;


FQBE : TStrings;


FRequestLive : Boolean;


FRowsAffected : Integer;


FStartParam : Char;


FStmtHandle : HDBIStmt;


FText : string;



Constructors


constructor Create(AOwner: TComponent);

TQBEQuery


Functions


destructor Destroy;


procedure ExecQBE;


function GetQBEText: PChar;

Retry


function IsEmpty: Boolean;


function ParamByName(const Value: string): TParam;


procedure Prepare;


procedure RefreshQuery;


procedure UnPrepare;


function CreateHandle: HDBICur;


procedure Disconnect;


function GetParamsCount: Word;


procedure SetDBFlag(Flag: Integer; Value: Boolean);


function CreateCursor(GenHandle: Boolean): HDBICur;


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


procedure FreeStatement;


function GetQueryCursor(GenHandle: Boolean): HDBICur;


function GetRowsAffected: Integer;


procedure GetStatementHandle(QBEText: PChar);


procedure PrepareQBE(Value: PChar);


procedure QueryChanged(Sender: TObject);


procedure ReplaceParams(QBEText: TStrings);


procedure SetParamsList(Value: TParams);


procedure SetPrepare(Value: Boolean);

ignore exceptions


procedure SetPrepared(Value: Boolean);

special QBE operator


procedure SetQuery(Value: TStrings);


procedure SetStartParam(Value: Char);


Properties


property AuxiliaryTables : Boolean


property BlankAsZero : Boolean

Ensure QBE is declared before Params


property ParamCheck : Boolean


property Params : TParams


property QBE : TStrings

Ensure StartParam is declared before QBE


property RequestLive : Boolean


property StartParam : Char


property UpdateMode :


property UpdateObject :


property Local : Boolean


property ParamCount : Word


property Prepared : Boolean


property RowsAffected : Integer


property StmtHandle : HDBIStmt


property Text : string


Events


Variables


FAuxiliaryTables : Boolean;


FBlankAsZero : Boolean;


FLocal : Boolean;


FParamCheck : Boolean;


FParams : TParams;


FPrepared : Boolean;


FQBE : TStrings;


FRequestLive : Boolean;


FRowsAffected : Integer;


FStartParam : Char;


FStmtHandle : HDBIStmt;


FText : string;