Unit msesqldb

Description
Classes, Interfaces, Objects and Records
Types
Constants

Description

This item has no description.

Overview

Classes, Interfaces, Objects and Records

Name Description
Class tmsesqltransaction  
Class tsqldscontroller  
Class tmsesqlquery 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.
Interface idbparaminfo  
Class tparamsourcedatalink  
Class tparamdestdatalink  
Class tdestvalue  
Class tdestparam  
Class tdestparams  
Class tdestfield  
Class tdestfields  
Class tfieldparamlink Refreshes destdataset whenever the source fieldname field (on the datasource dataset) changes value, by setting the destdataset parameter named paramname to it.
Class tsequencedatalink  
Class tsequencelink  

Types

fieldparamlinkoptionty = (...);
fieldparamlinkoptionsty = set of fieldparamlinkoptionty;
applyrecupdateeventty = procedure(const sender: tmsesqlquery; const updatekind: tupdatekind; var asql: msestring; var done: boolean) of object;
afterapplyrecupdateeventty = procedure(const sender: tmsesqlquery; const updatekind: tupdatekind) of object;
updateerroreventty = procedure(const sender: tmsesqlquery; const aupdatekind: tupdatekind; var aupdateaction: tupdateaction) of object;
setparameventty = procedure(const sender: tfieldparamlink; var done: boolean) of object;
destfieldoptionty = (...);
destfieldoptionsty = set of destfieldoptionty;

Constants

defaultfieldparamlinkoptions = [fplo_autorefresh,fplo_refreshifchangedonly];
defaultsqlcontrolleroptions = defaultdscontrolleroptions;
defaultsqlbdsoptions = defaultbufdatasetoptions + [bdo_autoapply,bdo_autocommitret];

Description

Types

fieldparamlinkoptionty = (...);

With fplo_autorefresh set (the default), the detail dataset is refreshed automatically after the linked field is modified. To filter the detail dataset optionally instead of always, extend its query with a "shortcut" condition such as where (pk = :selpar) or (:nofilterpar <> 0) and set the extra parameter through onsetparam — query parameters cannot be removed, only given a value that makes the condition always true.

Values
  • fplo_disabled
  • fplo_autorefresh
  • fplo_refreshifactiveonly
  • fplo_refreshifchangedonly
  • fplo_checkbrowsemodeonrefresh
  • fplo_restorerecno
  • fplo_syncmasterpost
  • fplo_delayedsyncmasterpost
  • fplo_syncmastercancel
  • fplo_syncmastercancelupdates
  • fplo_syncmasterapplyupdates
  • fplo_syncmastercheckbrowsemode
  • fplo_syncmasteredit
  • fplo_syncmasterinsert
  • fplo_syncmasterdelete
  • fplo_syncslavepost
  • fplo_delayedsyncslavepost
  • fplo_syncslavecancel
  • fplo_syncslaveedit
  • fplo_syncslaveinsert
  • fplo_syncslaveinserttoedit
  • fplo_syncslavedelete
  • fplo_syncslavedeletetoedit
fieldparamlinkoptionsty = set of fieldparamlinkoptionty;

This item has no description.

applyrecupdateeventty = procedure(const sender: tmsesqlquery; const updatekind: tupdatekind; var asql: msestring; var done: boolean) of object;

This item has no description.

afterapplyrecupdateeventty = procedure(const sender: tmsesqlquery; const updatekind: tupdatekind) of object;

This item has no description.

updateerroreventty = procedure(const sender: tmsesqlquery; const aupdatekind: tupdatekind; var aupdateaction: tupdateaction) of object;

This item has no description.

setparameventty = procedure(const sender: tfieldparamlink; var done: boolean) of object;

This item has no description.

destfieldoptionty = (...);

This item has no description.

Values
  • dfo_onlyifnull
  • dfo_notifunmodifiedinsert
destfieldoptionsty = set of destfieldoptionty;

This item has no description.

Constants

defaultfieldparamlinkoptions = [fplo_autorefresh,fplo_refreshifchangedonly];

This item has no description.

defaultsqlcontrolleroptions = defaultdscontrolleroptions;

This item has no description.

defaultsqlbdsoptions = defaultbufdatasetoptions + [bdo_autoapply,bdo_autocommitret];

This item has no description.

Generated by PasDoc 1.0.4.