Class tmsesqlquery

Description
Hierarchy
Methods
Properties

Unit

msesqldb

Declaration

type tmsesqlquery = class(tsqlquery, imselocate, idscontroller, igetdscontroller, isqlpropertyeditor, iactivatorclient)

Description

Stores all fetched data in memory, with the ability to save/reload a memory image to disk and maintain an offline change journal — so the whole result set must fit in memory. For a very large result set, or when the data does not need to be displayed or edited in widgets, use tsqlresult instead (which only buffers the current record) together with a tsqllookupbuffer, for less overhead. For moderate record counts, connect a tdblookupbuffer for fast lookups; with tmsesqlquery the find functions of tlocalindex are also available.

Hierarchy

Overview

Methods

Protected function getdefaultoptions(): bufdatasetoptionsty override;
Protected procedure dobeforeapplyupdate; override;
Protected procedure checkpendingupdates; override;
Protected procedure setactive(avalue: boolean); override;
Protected procedure setcontrolleractive(const avalue: boolean);
Protected procedure idscontroller.setactive= setcontrolleractive;
Protected procedure iactivatorclient.setactive= setcontrolleractive;
Protected procedure afterapply; override;
Protected procedure updateindexdefs; override;
Protected procedure sqlonchange(const sender: tobject);
Protected procedure loaded; override;
Protected procedure internalopen; override;
Protected procedure internalclose; override;
Protected procedure DoAfterDelete; override;
Protected procedure internalinsert; override;
Protected procedure internaldelete; override;
Protected procedure applyrecupdate(updatekind: tupdatekind); override;
Protected function getcanmodify: boolean; override;
Protected function getfieldclass(fieldtype: tfieldtype): tfieldclass; override;
Protected procedure dataevent(event: tdataevent; info: ptrint); override;
Protected function islocal: boolean; override;
Protected function stringmemo: boolean; override;
Protected procedure inheriteddataevent(const event: tdataevent; const info: ptrint);
Protected procedure inheritedcancel;
Protected procedure inheritedpost;
Protected procedure inheriteddelete();
Protected procedure inheritedinsert();
Protected function inheritedmoveby(const distance: integer): integer;
Protected procedure inheritedinternalinsert; virtual;
Protected procedure inheritedinternaldelete; virtual;
Protected procedure inheritedinternalopen;
Protected procedure inheritedinternalclose;
Protected procedure doidleapplyupdates() override;
Protected procedure afterpost(const sender: tdataset; var ok: boolean);
Public constructor create(aowner: tcomponent); override;
Public destructor destroy; override;
Public function isutf8: boolean; override;
Public procedure appendrecord(const values: array of const);
Public procedure appendrecord(const values: array of const; const aisnull: array of boolean);
Public function moveby(const distance: integer): integer;
Public procedure cancel; override;
Public function post1(): boolean;
Public procedure postoverride;
Public function delete1(): boolean;
Public procedure deleteoverride;
Public procedure applyupdates(const maxerrors: integer; const cancelonerror: boolean; const cancelondeleteerror: boolean = false; const editonerror: boolean = false); overload; override;
Public procedure applyupdates(const maxerrors: integer = 0); overload; override;
Public procedure applyupdate; overload; override;

Properties

Published property FieldDefs;
Published property delayedapplycount;
Published property options default defaultsqlbdsoptions;
Published property controller: tdscontroller read fcontroller write setcontroller;
Published property Active: boolean read getactive write setactive1 default false;
Published property onapplyrecupdate: applyrecupdateeventty read fonapplyrecupdate write setonapplyrecupdate;
Published property onapplyrecupdate2: afterapplyrecupdateeventty read fonapplyrecupdate2 write setonapplyrecupdate2;
Published property afterapplyrecupdate: afterapplyrecupdateeventty read fafterapplyrecupdate write fafterapplyrecupdate;
Published property UpdateMode default upWhereKeyOnly;
Published property UsePrimaryKeyAsKey default true;
Published property IndexDefs : TIndexDefs read getindexdefs write setindexdefs;

Description

Methods

Protected function getdefaultoptions(): bufdatasetoptionsty override;

This item has no description.

Protected procedure dobeforeapplyupdate; override;

This item has no description.

Protected procedure checkpendingupdates; override;

This item has no description.

Protected procedure setactive(avalue: boolean); override;

This item has no description.

Protected procedure setcontrolleractive(const avalue: boolean);

This item has no description.

Protected procedure idscontroller.setactive= setcontrolleractive;

This item has no description.

Protected procedure iactivatorclient.setactive= setcontrolleractive;

This item has no description.

Protected procedure afterapply; override;

This item has no description.

Protected procedure updateindexdefs; override;

This item has no description.

Protected procedure sqlonchange(const sender: tobject);

This item has no description.

Protected procedure loaded; override;

This item has no description.

Protected procedure internalopen; override;

This item has no description.

Protected procedure internalclose; override;

This item has no description.

Protected procedure DoAfterDelete; override;

This item has no description.

Protected procedure internalinsert; override;

This item has no description.

Protected procedure internaldelete; override;

This item has no description.

Protected procedure applyrecupdate(updatekind: tupdatekind); override;

This item has no description. Showing description inherited from tsqlquery.applyrecupdate.

The dataset is locked for the duration of applyrecupdate (and of the whole applyupdates it is called from) — avoid user interaction (e.g. showmessage) from an override or from the underlying "on apply record update" mechanism.

Protected function getcanmodify: boolean; override;

This item has no description.

Protected function getfieldclass(fieldtype: tfieldtype): tfieldclass; override;

This item has no description.

Protected procedure dataevent(event: tdataevent; info: ptrint); override;

This item has no description.

Protected function islocal: boolean; override;

This item has no description.

Protected function stringmemo: boolean; override;

This item has no description.

Protected procedure inheriteddataevent(const event: tdataevent; const info: ptrint);

This item has no description.

Protected procedure inheritedcancel;

This item has no description.

Protected procedure inheritedpost;

This item has no description.

Protected procedure inheriteddelete();

This item has no description.

Protected procedure inheritedinsert();

This item has no description.

Protected function inheritedmoveby(const distance: integer): integer;

This item has no description.

Protected procedure inheritedinternalinsert; virtual;

This item has no description.

Protected procedure inheritedinternaldelete; virtual;

This item has no description.

Protected procedure inheritedinternalopen;

This item has no description.

Protected procedure inheritedinternalclose;

This item has no description.

Protected procedure doidleapplyupdates() override;

This item has no description.

Protected procedure afterpost(const sender: tdataset; var ok: boolean);

This item has no description.

Public constructor create(aowner: tcomponent); override;

This item has no description.

Public destructor destroy; override;

This item has no description.

Public function isutf8: boolean; override;

This item has no description.

Public procedure appendrecord(const values: array of const);

This item has no description.

Public procedure appendrecord(const values: array of const; const aisnull: array of boolean);

This item has no description.

Public function moveby(const distance: integer): integer;

This item has no description.

Public procedure cancel; override;

This item has no description.

Public function post1(): boolean;

This item has no description.

Public procedure postoverride;

This item has no description.

Public function delete1(): boolean;

This item has no description.

Public procedure deleteoverride;

This item has no description.

Public procedure applyupdates(const maxerrors: integer; const cancelonerror: boolean; const cancelondeleteerror: boolean = false; const editonerror: boolean = false); overload; override;

This item has no description.

Public procedure applyupdates(const maxerrors: integer = 0); overload; override;

This item has no description.

Public procedure applyupdate; overload; override;

This item has no description.

Properties

Published property FieldDefs;

This item has no description.

Published property delayedapplycount;

This item has no description.

Published property options default defaultsqlbdsoptions;

This item has no description.

Published property controller: tdscontroller read fcontroller write setcontroller;

This item has no description.

Published property Active: boolean read getactive write setactive1 default false;

This item has no description.

Published property onapplyrecupdate: applyrecupdateeventty read fonapplyrecupdate write setonapplyrecupdate;

This item has no description.

Published property onapplyrecupdate2: afterapplyrecupdateeventty read fonapplyrecupdate2 write setonapplyrecupdate2;

This item has no description.

Published property afterapplyrecupdate: afterapplyrecupdateeventty read fafterapplyrecupdate write fafterapplyrecupdate;

This item has no description.

Published property UpdateMode default upWhereKeyOnly;

This item has no description.

Published property UsePrimaryKeyAsKey default true;

This item has no description. Showing description inherited from tsqlquery.UsePrimaryKeyAsKey.

When True (the default), the primary key field(s) automatically get of_InKey added to optionsfield (the pfInKey equivalent), so they are used in the "where" part of the update statement — whether the field is persistent or not. A calculated field must still have of_InUpdate removed from optionsfield manually to be excluded from the update statement. Also determines whether IndexDefs is populated.

Published property IndexDefs : TIndexDefs read getindexdefs write setindexdefs;

This item has no description.

Generated by PasDoc 1.0.4.