TSQLConnection class

Inheritance
Implementers

Constructors

TSQLConnection([TComponent? aOwner])

Properties

afterConnect ↔ TNotifyEvent?
getter/setter pairinherited
afterDisconnect ↔ TNotifyEvent?
getter/setter pairinherited
beforeConnect ↔ TNotifyEvent?
getter/setter pairinherited
beforeDisconnect ↔ TNotifyEvent?
getter/setter pairinherited
charSet ↔ String
getter/setter pair
codePage → int
no setter
componentCount → int
no setterinherited
componentState → TComponentState
finalinherited
connected ↔ bool
getter/setter pairinherited
connOptions ↔ TConnOptions
getter/setter pair
databaseName ↔ String
getter/setter pairinherited
dataSetCount → int
no setterinherited
directory ↔ String
getter/setter pairinherited
fieldNameQuoteChars ↔ TQuoteChars
getter/setter pair
forcedClose ↔ bool
getter/setter pairinherited
handle → dynamic
no setter
hashCode → int
The hash code for this object.
no setterinherited
hostName ↔ String
getter/setter pair
isSQLBased → bool
no setterinherited
keepConnection ↔ bool
getter/setter pairinherited
logEvents ↔ TDBEventTypes
getter/setter pair
loginPrompt ↔ bool
getter/setter pairinherited
name ↔ String
getter/setter pairinherited
onLog ↔ TDBLogNotifyEvent?
getter/setter pair
onLogin ↔ TLoginEvent?
getter/setter pairinherited
options ↔ TSQLConnectionOptions
getter/setter pair
owner → TComponent?
no setterinherited
params ↔ TStrings
getter/setter pairinherited
password ↔ String
getter/setter pair
port ↔ int
getter/setter pair
role ↔ String
getter/setter pair
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
sqlFormatSettings ↔ TFormatSettings
getter/setter pair
streamedConnected ↔ bool
getter/setter pairinherited
transaction ↔ TSQLTransaction?
getter/setter pair
transactionCount → int
no setterinherited
userName ↔ String
getter/setter pair

Methods

addFieldDef(TFieldDefs aFieldDefs, int aFieldNo, String aName, TFieldType aDataType, int aSize, int aPrecision, bool aByteSize, bool aRequired, bool aReadOnly) → TFieldDef
addFieldDefs(TSQLCursor cursor, TFieldDefs fieldDefs) → void
addFieldToUpdateWherePart(TStringRef sqlWhere, TUpdateMode updateMode, TField f, [TBoolRef? usedEmptyKey]) → void
allocateCursorHandle() → TSQLCursor
allocateTransactionHandle() → TSQLHandle
applyFieldUpdate(TSQLCursor? c, TSQLDBParam p, TField f, bool useOldValue) → void
applyRecUpdate(TCustomSQLQuery query, TUpdateKind updateKind) → void
assign(TPersistent? source) → void
inherited
assignTo(TPersistent dest) → void
inherited
attemptCommit(TSQLHandle trans) → bool
attemptRollBack(TSQLHandle trans) → bool
checkConnected() → void
inherited
checkDisConnected() → void
inherited
closeConnection([bool forceClose = false]) → void
inherited
closeDataSets() → void
inherited
closeTransactions() → void
inherited
commit(TSQLHandle trans) → bool
commitRetaining(TSQLHandle trans) → void
components(int index) → TComponent
inherited
constructDeleteSQL(TCustomSQLQuery query) → String
constructInsertSQL(TCustomSQLQuery query, TBoolRef returningClause) → String
constructRefreshSQL(TCustomSQLQuery query, TUpdateKind updateKind) → String
constructUpdateSQL(TCustomSQLQuery query, TBoolRef returningClause) → String
createCustomQuery(TComponent? aOwner) → TCustomSQLQuery
createDB() → void
dataSets(int index) → TDataSet?
inherited
deAllocateCursorHandle(TSQLCursor cursor) → void
destroy() → void
override
doConnect() → void
override
doDisconnect() → void
inherited
doInternalConnect() → void
override
doInternalDisConnect() → void
override
doLoginPrompt() → void
inherited
dropDB() → void
endTransaction() → void
override
execute(TSQLCursor cursor, TSQLTransaction? aTransaction, TParams? aParams) → void
executeDirect(String sql, [TSQLTransaction? aTransaction]) → void
fetch(TSQLCursor cursor) → bool
findComponent(String aName) → TComponent?
inherited
free() → void
inherited
freeFldBuffers(TSQLCursor cursor) → void
freeNotification(TComponent aComponent) → void
inherited
getAsSQLTextField(TField? field) → String
getAsSQLTextParam(TParam? param) → String
getConnected() → bool
inherited
getConnectionCharSet() → String
getConnectionInfo(TConnInfoType infoType) → String
getDataSet(int index) → TDataSet?
inherited
getDataSetCount() → int
inherited
getDBInfo(TSchemaType aSchemaType, String aSchemaObjectName, String aReturnField, TStrings aList) → void
getFieldNames(covariant dynamic tableNameOrList, [TStrings? list]) → void
getHandle() → dynamic
getLoginParams(TStringRef aDatabaseName, TStringRef aUserName, TStringRef aPassword) → void
inherited
getNextValue(String sequenceName, [int incrementBy = 1]) → int
getNextValueSQL(String sequenceName, int incrementBy) → String
getObjectNames(TSchemaType aSchemaType, TSqlObjectIdentifierList aList) → int
getParamAsString(TParam param) → String
getProcedureNames(TStrings list) → void
getSchemaInfoSQL(TSchemaType schemaType, String schemaObjectName, String schemaPattern) → String
getSchemaNames(TStrings list) → void
getSequenceNames(TStrings list) → void
getStatementInfo(String aSQL) → TSQLStatementInfo
getTableNames(TStrings list, [bool systemTables = false]) → void
getTransactionHandle(TSQLHandle trans) → dynamic
initialiseUpdateStatement(TCustomSQLQuery query, TQueryRef qryRef) → TCustomSQLQuery
internalHandleException() → void
inherited
loadBlobIntoBuffer(TFieldDef fieldDef, PBufBlobField aBlobBuf, TSQLCursor cursor, TSQLTransaction? aTransaction) → void
loaded() → void
inherited
loadField(TSQLCursor cursor, TFieldDef fieldDef, TValueBuffer buffer, TBoolRef createBlob) → bool
log(TDBEventType eventType, String msg) → void
logEvent(TDBEventType eventType) → bool
logParams(TParams? aParams) → void
maybeConnect() → void
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
notification(TComponent aComponent, TOperation operation) → void
inherited
openConnection() → void
inherited
prepareStatement(TSQLCursor cursor, TSQLTransaction? aTransaction, String buf, TParams? aParams) → void
refreshLastInsertID(TCustomSQLQuery query, TField field) → bool
registerDataset(TDBDataset ds) → void
inherited
registerStatement(TCustomSQLStatement s) → void
registerTransaction(TDBTransaction ta) → void
inherited
removeDataSets() → void
inherited
removeFreeNotification(TComponent aComponent) → void
inherited
removeTransactions() → void
inherited
rollBack(TSQLHandle trans) → bool
rollBackRetaining(TSQLHandle trans) → void
rowsAffected(TSQLCursor? cursor) → TRowsCount
setConnected(bool value) → void
inherited
setLoginParams(String aDatabaseName, String aUserName, String aPassword) → void
inherited
startDBTransaction(TSQLHandle trans, String aParams) → bool
startImplicitTransaction(TSQLHandle trans, String aParams) → bool
startTransaction() → void
override
strToStatementType(String s) → TStatementType
toString() → String
A string representation of this object.
inherited
transactions(int index) → TDBTransaction
inherited
unPrepareStatement(TSQLCursor cursor) → void
unregisterDataset(TDBDataset ds) → void
inherited
unRegisterStatement(TCustomSQLStatement s) → void
unregisterTransaction(TDBTransaction ta) → void
inherited
updateIndexDefsFor(TIndexDefs indexDefs, String tableName) → void

Operators

operator ==(Object other) → bool
The equality operator.
inherited