Unit msqldb

Description
Classes, Interfaces, Objects and Records
Functions and Procedures
Types
Constants

Description

This item has no description.

Overview

Classes, Interfaces, Objects and Records

Name Description
Class tsqlstringlist  
Class TSQLHandle  
Interface icursorclient  
Class TSQLCursor  
Class econnectionerror  
Class tdbcontroller  
Class tcustomsqlconnection  
Class tsqlconnection  
Class TSQLTransaction  
Class tcustomsqlstatement  
Class tmsesqlscript Executes each statement of SQL (split on term) in turn.
Class tcursorsqlstatement  
Class tsqlstatement  
Interface iblobconnection  
Interface isqlclient  

Functions and Procedures

procedure updateparams(const aparams: tmseparams; const autf8: boolean);
procedure doexecute(const aparams: tmseparams; const atransaction: tmdbtransaction; const acursor: tsqlcursor; adatabase: tmdatabase; const autf8: boolean);
procedure checksqlconnection(const aname: ansistring; const avalue: tmdatabase);
procedure checksqltransaction(const aname: ansistring; const avalue: tmdbtransaction);
procedure dosetsqldatabase(const sender: isqlclient; const avalue: tmdatabase; var acursor: tsqlcursor; var dest: tmdatabase);
function splitsql(const asql: msestring; const term: msechar = ';'; const charescapement: boolean = false): msestringarty;

Types

TSchemaType = (...);
sqlconnoptionty = (...);
sqlconnoptionsty = set of sqlconnoptionty;
TStatementType = (...);
getcredentialseventty = procedure(const sender: tcustomsqlconnection; var ausername: msestring; var apassword: msestring) of object;
TCommitRollbackAction = (...);
transactionoptionty = (...);
transactionoptionsty = set of transactionoptionty;
sqltransactioneventty = procedure(const sender: tsqltransaction) of object;
commiterroreventty = procedure(const sender: tsqltransaction; const aexception: exception; var handled: boolean) of object;
sqlstatementeventty = procedure(const sender: tcustomsqlstatement; const adatabase: tcustomsqlconnection; const atransaction: tsqltransaction) of object;
sqlstatementerroreventty = procedure(const sender: tcustomsqlstatement; const adatabase: tcustomsqlconnection; const atransaction: tsqltransaction; const e: exception; var handled: boolean) of object;
sqlstatementoptionty = (...);
sqlstatementoptionsty = set of sqlstatementoptionty;
msesqlscripteventty = procedure(const sender: tmsesqlscript) of object;

Constants

updatestatementtypes: array[tupdatekind] of tstatementtype = (stupdate, stinsert, stdelete);
StatementTokens : Array[TStatementType] of msestring = ('(none)', 'select', 'insert', 'update', 'delete', 'create', 'get', 'put', 'execute', 'start','commit','rollback', '?' );
datareturningtypes = [stselect,stexecprocedure];
blobidsize = sizeof(integer);

Description

Functions and Procedures

procedure updateparams(const aparams: tmseparams; const autf8: boolean);

This item has no description.

procedure doexecute(const aparams: tmseparams; const atransaction: tmdbtransaction; const acursor: tsqlcursor; adatabase: tmdatabase; const autf8: boolean);

This item has no description.

procedure checksqlconnection(const aname: ansistring; const avalue: tmdatabase);

This item has no description.

procedure checksqltransaction(const aname: ansistring; const avalue: tmdbtransaction);

This item has no description.

procedure dosetsqldatabase(const sender: isqlclient; const avalue: tmdatabase; var acursor: tsqlcursor; var dest: tmdatabase);

This item has no description.

function splitsql(const asql: msestring; const term: msechar = ';'; const charescapement: boolean = false): msestringarty;

This item has no description.

Types

TSchemaType = (...);

This item has no description.

Values
  • stNoSchema
  • stTables
  • stSysTables
  • stProcedures
  • stColumns
  • stProcedureParams
  • stIndexes
  • stPackages
sqlconnoptionty = (...);

This item has no description.

Values
  • sco_supportparams
  • sco_forceparams
  • sco_emulateretaining
  • sco_nounprepared
  • sco_blobscached
sqlconnoptionsty = set of sqlconnoptionty;

This item has no description.

TStatementType = (...);

This item has no description.

Values
  • stNone
  • stSelect
  • stInsert
  • stUpdate
  • stDelete
  • stDDL
  • stGetSegment
  • stPutSegment
  • stExecProcedure
  • stStartTrans
  • stCommit
  • stRollback
  • stSelectForUpd
getcredentialseventty = procedure(const sender: tcustomsqlconnection; var ausername: msestring; var apassword: msestring) of object;

This item has no description.

TCommitRollbackAction = (...);

This item has no description.

Values
  • caNone
  • caCommit
  • caCommitRetaining
  • caRollback
  • caRollbackRetaining
transactionoptionty = (...);

tao_fake makes the transaction not really start a DB transaction at all (the connection works without transactions). tao_fakeretaining is for backends without native CommitRetaining/RollbackRetaining (e.g. Postgres, unlike Firebird): it simulates them by closing and reopening the transaction — unlike with a real retaining commit/rollback, bookmarks taken before it become invalid. RollbackRetaining always refetches the bound datasets; on CommitRetaining this only happens if tao_refreshdatasets is also set (useful to pick up changes made by other sessions) — datasets that were inactive are reactivated either way.

Values
  • tao_fake
  • tao_fakeretaining
  • tao_catcherror
  • tao_rollbackonerror
  • tao_refreshdatasets
transactionoptionsty = set of transactionoptionty;

This item has no description.

sqltransactioneventty = procedure(const sender: tsqltransaction) of object;

This item has no description.

commiterroreventty = procedure(const sender: tsqltransaction; const aexception: exception; var handled: boolean) of object;

This item has no description.

sqlstatementeventty = procedure(const sender: tcustomsqlstatement; const adatabase: tcustomsqlconnection; const atransaction: tsqltransaction) of object;

This item has no description.

sqlstatementerroreventty = procedure(const sender: tcustomsqlstatement; const adatabase: tcustomsqlconnection; const atransaction: tsqltransaction; const e: exception; var handled: boolean) of object;

This item has no description.

sqlstatementoptionty = (...);

This item has no description.

Values
  • sso_utf8
  • sso_autocommit
  • sso_autocommitret
  • sso_noprepare
  • sso_savepoint
sqlstatementoptionsty = set of sqlstatementoptionty;

This item has no description.

msesqlscripteventty = procedure(const sender: tmsesqlscript) of object;

This item has no description.

Constants

updatestatementtypes: array[tupdatekind] of tstatementtype = (stupdate, stinsert, stdelete);

This item has no description.

StatementTokens : Array[TStatementType] of msestring = ('(none)', 'select', 'insert', 'update', 'delete', 'create', 'get', 'put', 'execute', 'start','commit','rollback', '?' );

This item has no description.

datareturningtypes = [stselect,stexecprocedure];

This item has no description.

blobidsize = sizeof(integer);

This item has no description.

Generated by PasDoc 1.0.4.