Class TQueryUDB

DescriptionHierarchyFieldsMethodsProperties

Unit

Declaration

type TQueryUDB = class

Description

TQueryUDB - descendant of TADOQuery/TZQuery/TSimpleDataSet/TIBQuery/TpFIBDataSet

Overview

Methods

Protected procedure Loaded; override;
Protected function GetCanModify: boolean; override;
Protected procedure DoBeforeOpen; override;
Protected procedure DoAfterOpen; override;
Protected procedure DoBeforeClose; override;
Protected procedure DoAfterClose; override;
Protected procedure DoBeforePost; override;
Protected procedure DoAfterPost; override;
Protected procedure DoBeforeScroll; override;
Protected procedure DoAfterScroll; override;
Protected procedure DoBeforeCancel; override;
Protected procedure DoAfterCancel; override;
Protected procedure DoBeforeInsert; override;
Protected procedure DoAfterInsert; override;
Protected procedure DoBeforeEdit; override;
Protected procedure DoAfterEdit; override;
Protected procedure DoBeforeDelete; override;
Protected procedure DoAfterDelete; override;
Protected procedure CallDatasetEvent(Event: TDatasetEventType);
Protected procedure ProcControlsToUpdate(Event: TDatasetEventType);
Public procedure SetReadOnly(Value: boolean);
Public procedure SetSortEx(const ASort: string);
Public procedure RequeryEx(ChangeCursor: boolean = true);
Public procedure SetSQLWhere(const Condition: string); overload;
Public procedure SetSQLWhere(const FormatCondition: string; Value: variant); overload;
Public procedure SetSQLWhere(Field: TField); overload;
Public procedure SetSQLWhere(Field: TField; Value: variant); overload;
Public procedure AddSQLWhereOR(const Condition: string);
Public procedure AddSQLWhereAND(const Condition: string);
Public function SetExecSQL(const SQLCmd: string): integer;
Public procedure SetFieldDefaultFormat;
Public procedure LoadFieldsProps;
Public function GetTableName: string;
Public procedure UpdateDatasetState;
Public function IsEditing: boolean;
Public function IsNewRec: boolean;
Public function HasFieldToDuplic: boolean;
Public function SetFieldsReadOnly: integer;
Public function DuplicateRecord: boolean;
Public procedure AddEventNotify(CallBackProc: TDataSetEvent);
Public procedure RemoveEventNotify(CallBackProc: TDataSetEvent);

Properties

Published property DataSetField;
Published property TableName: string read FTableName write FTableName;
Published property IdFieldName: string read FIdFieldName write FIdFieldName;
Published property FieldImgIdx: TStrings read FFieldImgIdx write SetFieldImgIdx;
Published property FieldPropsAutoLoad: boolean read FFieldPropsAutoLoad write FFieldPropsAutoLoad default true;
Published property FieldDefFormatAutoSet: boolean read FFieldDefFormatAutoSet write FFieldDefFormatAutoSet default true;
Published property ControlsToUpdate: TStrings read FControlsToUpdate write SetControlsToUpdate;
Published property ControlsReadOnlyColor: TColor read FControlsReadOnlyColor write FControlsReadOnlyColor default clBtnFace;
Published property ConfirmDelete: boolean read FConfirmDelete write FConfirmDelete default false;
Published property ReadOnly: boolean read GetReadOnly write SetReadOnly default false;
Published property FieldTagToDuplic: byte read FFieldTagToDuplic write FFieldTagToDuplic default 1;
Published property FieldTagToReadOnly: byte read FFieldTagToReadOnly write FFieldTagToReadOnly default 2;
Published property CheckFieldSizeBeforePost: boolean read FCheckFieldSizeBeforePost write FCheckFieldSizeBeforePost default false;
Published property SQL: TStrings read GetSQL write SetSQL;
Published property Connection: read GetConnection write SetConnection;
Published property OnDataSetEvent: TDataSetEvent read FDataSetEvent write FDataSetEvent;

Description

Methods

Protected procedure Loaded; override;
 
Protected function GetCanModify: boolean; override;
 
Protected procedure DoBeforeOpen; override;
 
Protected procedure DoAfterOpen; override;
 
Protected procedure DoBeforeClose; override;
 
Protected procedure DoAfterClose; override;
 
Protected procedure DoBeforePost; override;
 
Protected procedure DoAfterPost; override;
 
Protected procedure DoBeforeScroll; override;
 
Protected procedure DoAfterScroll; override;
 
Protected procedure DoBeforeCancel; override;
 
Protected procedure DoAfterCancel; override;
 
Protected procedure DoBeforeInsert; override;
 
Protected procedure DoAfterInsert; override;
 
Protected procedure DoBeforeEdit; override;
 
Protected procedure DoAfterEdit; override;
 
Protected procedure DoBeforeDelete; override;
 
Protected procedure DoAfterDelete; override;
 
Protected procedure CallDatasetEvent(Event: TDatasetEventType);
 
Protected procedure ProcControlsToUpdate(Event: TDatasetEventType);
 
Public procedure SetReadOnly(Value: boolean);
 
Public procedure SetSortEx(const ASort: string);
 
Public procedure RequeryEx(ChangeCursor: boolean = true);
 
Public procedure SetSQLWhere(const Condition: string); overload;
 
Public procedure SetSQLWhere(const FormatCondition: string; Value: variant); overload;
 
Public procedure SetSQLWhere(Field: TField); overload;
 
Public procedure SetSQLWhere(Field: TField; Value: variant); overload;
 
Public procedure AddSQLWhereOR(const Condition: string);
 
Public procedure AddSQLWhereAND(const Condition: string);
 
Public function SetExecSQL(const SQLCmd: string): integer;
 
Public procedure SetFieldDefaultFormat;
 
Public procedure LoadFieldsProps;
 
Public function GetTableName: string;
 
Public procedure UpdateDatasetState;
 
Public function IsEditing: boolean;
 
Public function IsNewRec: boolean;
 
Public function HasFieldToDuplic: boolean;
 
Public function SetFieldsReadOnly: integer;
 
Public function DuplicateRecord: boolean;
 
Public procedure AddEventNotify(CallBackProc: TDataSetEvent);
 
Public procedure RemoveEventNotify(CallBackProc: TDataSetEvent);
 

Properties

Published property DataSetField;
 
Published property TableName: string read FTableName write FTableName;
 
Published property IdFieldName: string read FIdFieldName write FIdFieldName;
 
Published property FieldImgIdx: TStrings read FFieldImgIdx write SetFieldImgIdx;
 
Published property FieldPropsAutoLoad: boolean read FFieldPropsAutoLoad write FFieldPropsAutoLoad default true;
 
Published property FieldDefFormatAutoSet: boolean read FFieldDefFormatAutoSet write FFieldDefFormatAutoSet default true;
 
Published property ControlsToUpdate: TStrings read FControlsToUpdate write SetControlsToUpdate;
 
Published property ControlsReadOnlyColor: TColor read FControlsReadOnlyColor write FControlsReadOnlyColor default clBtnFace;
 
Published property ConfirmDelete: boolean read FConfirmDelete write FConfirmDelete default false;
 
Published property ReadOnly: boolean read GetReadOnly write SetReadOnly default false;
 
Published property FieldTagToDuplic: byte read FFieldTagToDuplic write FFieldTagToDuplic default 1;
 
Published property FieldTagToReadOnly: byte read FFieldTagToReadOnly write FFieldTagToReadOnly default 2;
 
Published property CheckFieldSizeBeforePost: boolean read FCheckFieldSizeBeforePost write FCheckFieldSizeBeforePost default false;
 
Published property SQL: TStrings read GetSQL write SetSQL;
 
Published property Connection: read GetConnection write SetConnection;
 
Published property OnDataSetEvent: TDataSetEvent read FDataSetEvent write FDataSetEvent;
 

Generated by PasDoc 0.13.0 on 2017-06-17 14:57:14