tmsesqlquery

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

  <TPasMethodResolution>

Stores all fetched data in memory, with the ability to save/reload a memory image to disk and maintain an offline change journal

  <TPasMethodResolution>

Stores all fetched data in memory, with the ability to save/reload a memory image to disk and maintain an offline change journal

public

  constructor create(); override;

  destructor destroy; override;

  function isutf8; override;

  procedure appendrecord();

  function moveby();

  procedure cancel; override;

  function post1;

  procedure post; override;

  function delete1;

  procedure delete; override;

  procedure applyupdates();

  procedure applyupdate; override; overload;

published

  property FieldDefs;

  property delayedapplycount: Integer;

  property options: bufdatasetoptionsty;

  property controller: tdscontroller; [rw]

  property Active: Boolean; [rw]

  property onapplyrecupdate: applyrecupdateeventty; [rw]

Called for each modified, inserted or deleted record on applyupdates, to replace the automatically generated update statement, e.g. for a query on a join

  property onapplyrecupdate2: afterapplyrecupdateeventty; [rw]

  property afterapplyrecupdate: afterapplyrecupdateeventty; [rw]

  property UpdateMode: TUpdateMode;

  property UsePrimaryKeyAsKey: Boolean;

  property IndexDefs: TIndexDefs; [rw]

end;

tmsesqlquery

Stores all fetched data in memory, with the ability to save/reload a memory image to disk and maintain an offline change journal

tsqlquery,imselocate,idscontroller,igetdscontroller,isqlpropertyeditor,iactivatorclient

Holds a buffer of all records fetched by SQL; the db*edit widgets work from and to this buffer, not directly against the database

tmsebufdataset,isqlclient,icursorclient

Keeps three buffers: the record buffer holds all fetched records (fkdata and fkinternalcalc field values — see oninternalcalcfields)

tmdbdataset,iblobchache,idatasetsum,imasterlink,idbdata,iobjectlink

TObject,idatabaseclient,itransactionclient