TSQLQuery class
- Inheritance
- Available extensions
Constructors
- TSQLQuery([TComponent? aOwner])
Properties
- active ↔ bool
-
getter/setter pairinherited
- activeRecordIndex → int
-
no setterinherited
- afterCancel ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- afterClose ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- afterDelete ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- afterEdit ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- afterInsert ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- afterOpen ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- afterPost ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- afterRefresh ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- afterScroll ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- alwaysUpdateable ↔ bool
-
getter/setter pairinherited
-
applyingNewValues
→ Map<
String, dynamic> -
no setterinherited
-
applyingOldValues
→ Map<
String, dynamic> -
no setterinherited
- autoCalcFields ↔ bool
-
getter/setter pairinherited
- beforeCancel ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- beforeClose ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- beforeDelete ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- beforeEdit ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- beforeInsert ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- beforeOpen ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- beforePost ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- beforeRefresh ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- beforeScroll ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- blobFieldCount → int
-
no setterinherited
- blockReadSize ↔ int
-
getter/setter pairinherited
- bof → bool
-
no setterinherited
- bookmark ↔ Uint8List?
-
getter/setter pairinherited
- bookmarkSize ↔ int
-
getter/setter pairinherited
- bufferCount → int
-
no setterinherited
- calcBuffer → TRecordBuffer?
-
no setterinherited
- calcFieldsSize → int
-
no setterinherited
- canModify → bool
-
no setterinherited
- changeCount → int
-
no setterinherited
- componentCount → int
-
no setterinherited
- componentState → TComponentState
-
finalinherited
- constraints ↔ TCheckConstraints
-
getter/setter pairinherited
- currentRecordIndex → int
-
no setterinherited
- cursor → TSQLCursor?
-
no setterinherited
- database ↔ TDatabase?
-
getter/setter pairinherited
- dataSource ↔ TDataSource?
-
getter/setter pairinherited
- defaultFields → bool
-
no setterinherited
- deleteSQL ↔ TStringList
-
getter/setter pairinherited
- eof → bool
-
no setterinherited
- fieldCount → int
-
no setterinherited
- fieldDefs ↔ TFieldDefs
-
getter/setter pairinherited
- fields → TFields
-
no setterinherited
- filter ↔ String
-
getter/setter pairinherited
- filtered ↔ bool
-
getter/setter pairinherited
- filterOptions ↔ TFilterOptions
-
getter/setter pairinherited
- forceUpdateable ← bool
-
no getterinherited
- found → bool
-
no setterinherited
- hashCode → int
-
The hash code for this object.
no setterinherited
- indexDefs → TIndexDefs
-
no setterinherited
- indexFieldNames ↔ String
-
getter/setter pairinherited
- insertSQL ↔ TStringList
-
getter/setter pairinherited
- internalCalcFields → bool
-
no setterinherited
- isEmpty → bool
-
no setterinherited
- isUniDirectional → bool
-
no setterinherited
- macroChar ↔ String
-
getter/setter pairinherited
- macroCheck ↔ bool
-
getter/setter pairinherited
- macros ↔ TParams
-
getter/setter pairinherited
- maxIndexesCount ↔ int
-
getter/setter pairinherited
- modified → bool
-
no setterinherited
- myDataSourceCount → int
-
no setterinherited
- name ↔ String
-
getter/setter pairinherited
- onCalcFields ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- onDeleteError ↔ TDataSetErrorEvent?
-
getter/setter pairinherited
- onEditError ↔ TDataSetErrorEvent?
-
getter/setter pairinherited
- onFilterRecord ↔ TFilterRecordEvent?
-
getter/setter pairinherited
- onNewRecord ↔ TDataSetNotifyEvent?
-
getter/setter pairinherited
- onPostError ↔ TDataSetErrorEvent?
-
getter/setter pairinherited
- options ↔ TSQLQueryOptions
-
getter/setter pairinherited
- owner → TComponent?
-
no setterinherited
- packetRecords ↔ int
-
getter/setter pairinherited
- paramCheck ↔ bool
-
getter/setter pairinherited
- params ↔ TParams
-
getter/setter pairinherited
- parseSQL ↔ bool
-
getter/setter pairinherited
- prepared → bool
-
no setterinherited
- readOnly ↔ bool
-
getter/setter pairinherited
- recNo ↔ int
-
getter/setter pairinherited
- recordCount → int
-
no setterinherited
- recordSize → int
-
no setterinherited
- refreshing → bool
-
no setterinherited
- refreshSQL ↔ TStringList
-
getter/setter pairinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- schemaType → TSchemaType
-
no setterinherited
- sequence ↔ TSQLSequence?
-
getter/setter pairinherited
- serverFilter ↔ String
-
getter/setter pairinherited
- serverFiltered ↔ bool
-
getter/setter pairinherited
- serverIndexDefs → TServerIndexDefs
-
no setterinherited
- sql ↔ TStringList
-
getter/setter pairinherited
- sqlConnection ↔ TSQLConnection?
-
getter/setter pairinherited
- sqlTransaction ↔ TSQLTransaction?
-
getter/setter pairinherited
- state → TDataSetState
-
no setterinherited
- statementType → TStatementType
-
no setterinherited
- transaction ↔ TDBTransaction?
-
getter/setter pairinherited
- uniDirectional ↔ bool
-
getter/setter pairinherited
- updateMode ↔ TUpdateMode
-
getter/setter pairinherited
- updateSQL ↔ TStringList
-
getter/setter pairinherited
- updateTableName ↔ String
-
getter/setter pairinherited
- usePrimaryKeyAsKey ↔ bool
-
getter/setter pairinherited
Methods
-
activateBuffers(
) → void -
inherited
-
activeBuffer(
) → TRecordBuffer? -
inherited
-
addFilter(
String sqlStr) → String -
inherited
-
allocRecordBuffer(
) → TRecordBuffer? -
inherited
-
append(
) → void -
inherited
-
appendRecord(
List values) → void -
inherited
-
applyFilter(
) → void -
inherited
-
applyRecUpdate(
TUpdateKind updateKind) → void -
inherited
-
applyReturningResult(
TCustomSQLQuery q, TUpdateKind updateKind) → void -
inherited
-
applyUpdates(
[int maxErrors = 0]) → void -
inherited
-
applyUpdatesAsync(
[int maxErrors = 0]) → Future< void> -
Available on TCustomSQLQuery, provided by the TWapSQLQueryAsync extension
@@@ Replays the update log → await to send it. Backend errors surface here. -
assign(
TPersistent? source) → void -
inherited
-
assignTo(
TPersistent dest) → void -
inherited
-
beforeRefreshOpenCursor(
) → void -
inherited
-
bindFields(
bool binding) → void -
inherited
-
blockReadNext(
) → void -
inherited
-
bookmarkAvailable(
) → bool -
inherited
-
bookmarkValid(
TBookmark? aBookmark) → bool -
inherited
-
calculateFields(
TRecordBuffer buffer) → void -
inherited
-
cancel(
) → void -
inherited
-
cancelUpdates(
) → void -
inherited
-
checkActive(
) → void -
inherited
-
checkBiDirectional(
) → void -
inherited
-
checkBrowseMode(
) → void -
inherited
-
checkDatabase(
) → void -
inherited
-
checkInactive(
) → void -
inherited
-
checkPrepare(
) → void -
inherited
-
checkUnPrepare(
) → void -
inherited
-
clearBuffers(
) → void -
inherited
-
clearCalcFields(
TRecordBuffer buffer) → void -
inherited
-
clearFields(
) → void -
inherited
-
close(
) → void -
inherited
-
closeBlob(
TField field) → void -
inherited
-
closeCursor(
) → void -
inherited
-
compareBookmarks(
TBookmark? bookmark1, TBookmark? bookmark2) → int -
inherited
-
components(
int index) → TComponent -
inherited
-
controlsDisabled(
) → bool -
inherited
-
createBlobStream(
TField field, TBlobStreamMode mode) → TStream? -
inherited
-
createFields(
) → void -
inherited
-
createParams(
) → TSQLDBParams -
inherited
-
createSQLStatement(
TComponent? aOwner) → TCustomSQLStatement -
inherited
-
cursorPosChanged(
) → void -
inherited
-
dataConvert(
TField aField, TValueBuffer aSource, TValueBuffer aDest, bool aToNative) → void -
inherited
-
dataEvent(
TDataEvent event, dynamic info) → void -
inherited
-
delete(
) → void -
inherited
-
destroy(
) → void -
inherited
-
destroyFields(
) → void -
inherited
-
disableControls(
) → void -
inherited
-
doAfterCancel(
) → void -
inherited
-
doAfterClose(
) → void -
inherited
-
doAfterDelete(
) → void -
inherited
-
doAfterEdit(
) → void -
inherited
-
doAfterInsert(
) → void -
inherited
-
doAfterOpen(
) → void -
inherited
-
doAfterPost(
) → void -
inherited
-
doAfterRefresh(
) → void -
inherited
-
doAfterScroll(
) → void -
inherited
-
doBeforeCancel(
) → void -
inherited
-
doBeforeClose(
) → void -
inherited
-
doBeforeDelete(
) → void -
inherited
-
doBeforeEdit(
) → void -
inherited
-
doBeforeInsert(
) → void -
inherited
-
doBeforeOpen(
) → void -
inherited
-
doBeforePost(
) → void -
inherited
-
doBeforeRefresh(
) → void -
inherited
-
doBeforeScroll(
) → void -
inherited
-
doOnCalcFields(
) → void -
inherited
-
doOnNewRecord(
) → void -
inherited
-
edit(
) → void -
inherited
-
enableControls(
) → void -
inherited
-
execSQL(
) → void -
inherited
-
execSQLAsync(
) → Future< TRowsCount> -
Available on TCustomSQLQuery, provided by the TWapSQLQueryAsync extension
@@@ DML: synchronous execSQL into the queue → await to send it. @@@ Returns rowsAffected after flushing (the value cached inside the synchronous execSQL is @@@ -1 before flushing; what's returned here is the real backend value) -
execute(
) → void -
inherited
-
fetch(
) → bool -
inherited
-
fieldByName(
String fieldName) → TField -
inherited
-
fieldByNumber(
int fieldNo) → TField? -
inherited
-
fieldDefsClass(
) → TFieldDefs -
inherited
-
fieldsClass(
) → TFields -
inherited
-
fieldValues(
String fieldName) → dynamic -
inherited
-
findComponent(
String aName) → TComponent? -
inherited
-
findField(
String fieldName) → TField? -
inherited
-
findFirst(
) → bool -
inherited
-
findLast(
) → bool -
inherited
-
findNext(
) → bool -
inherited
-
findPrior(
) → bool -
inherited
-
findRecord(
bool restart, bool goForward) → bool -
inherited
-
first(
) → void -
inherited
-
free(
) → void -
inherited
-
freeBookmark(
TBookmark? aBookmark) → void -
inherited
-
freeFieldBuffers(
) → void -
inherited
-
freeFldBuffers(
) → void -
inherited
-
freeNotification(
TComponent aComponent) → void -
inherited
-
freeRecordBuffer(
TRecordBuffer buffer) → void -
inherited
-
getBookmark(
) → Uint8List? -
inherited
-
getBookmarkData(
TRecordBuffer buffer, TValueBuffer data) → void -
inherited
-
getBookmarkFlag(
TRecordBuffer buffer) → TBookmarkFlag -
inherited
-
getBookmarkStr(
) → String -
inherited
-
getBuffer(
int index) → TRecordBuffer? -
inherited
-
getCalcFields(
TRecordBuffer buffer) → void -
inherited
-
getCanModify(
) → bool -
inherited
-
getCurrentRecord(
TRecordBuffer buffer) → bool -
inherited
-
getDataSource(
) → TDataSource? -
inherited
-
getField(
int index) → TField -
inherited
-
getFieldClass(
TFieldType fieldType) → TFieldClass? -
inherited
-
getFieldData(
TField field, TValueBuffer? buffer, [bool nativeFormat = true]) → bool -
inherited
-
getFieldDataNative(
TField field, TValueBuffer? buffer) → bool -
inherited
-
getFieldList(
List< TField> list, String fieldNames) → void -
inherited
-
getFieldNames(
TStrings list) → void -
inherited
-
getIndexDefs(
TIndexDefs indexDefs, TIndexOptions indexTypes) → TIndexDefs -
inherited
-
getIsIndexField(
TField field) → bool -
inherited
-
getNextRecord(
) → bool -
inherited
-
getNextRecords(
) → int -
inherited
-
getPriorRecord(
) → bool -
inherited
-
getPriorRecords(
) → int -
inherited
-
getRecNo(
) → int -
inherited
-
getRecord(
TRecordBuffer buffer, TGetMode getMode, bool doCheck) → TGetResult -
inherited
-
getRecordCountInternal(
) → int -
inherited
-
getRecordSize(
) → int -
inherited
-
getStatementType(
) → TStatementType -
inherited
-
gotoBookmark(
TBookmark? aBookmark) → void -
inherited
-
initFieldDefs(
) → void -
inherited
-
initFieldDefsFromFields(
) → void -
inherited
-
initRecord(
TRecordBuffer buffer) → void -
inherited
-
insert(
) → void -
inherited
-
insertRecord(
List values) → void -
inherited
-
internalAddRecord(
dynamic buffer, bool aAppend) → void -
inherited
-
internalCancel(
) → void -
inherited
-
internalClose(
) → void -
inherited
-
internalDelete(
) → void -
inherited
-
internalEdit(
) → void -
inherited
-
internalFirst(
) → void -
inherited
-
internalGotoBookmark(
dynamic aBookmark) → void -
inherited
-
internalHandleException(
) → void -
inherited
-
internalInitFieldDefs(
) → void -
inherited
-
internalInitRecord(
TRecordBuffer buffer) → void -
inherited
-
internalInsert(
) → void -
inherited
-
internalLast(
) → void -
inherited
-
internalOpen(
) → void -
inherited
-
internalPost(
) → void -
inherited
-
internalRefresh(
) → void -
inherited
-
internalSetToRecord(
TRecordBuffer buffer) → void -
inherited
-
isCursorOpen(
) → bool -
inherited
-
isLinkedTo(
TDataSource? aDataSource) → bool -
inherited
-
isPrepared(
) → bool -
inherited
-
isReadFromPacket(
) → bool -
inherited
-
isSequenced(
) → bool -
inherited
-
last(
) → void -
inherited
-
loadBlobIntoBuffer(
TFieldDef fieldDef, PBufBlobField aBlobBuf) → void -
inherited
-
loaded(
) → void -
inherited
-
loadField(
TFieldDef fieldDef, TValueBuffer buffer, TBoolRef createBlob) → bool -
inherited
-
locate(
String keyFields, dynamic keyValues, TLocateOptions options) → bool -
inherited
-
log(
TDBEventType eventType, String msg) → void -
inherited
-
logEvent(
TDBEventType eventType) → bool -
inherited
-
lookup(
String keyFields, dynamic keyValues, String resultFields) → dynamic -
inherited
-
lookupMap(
String keyField, List< String> cols) → Map<String, List< String> > -
macroByName(
String aParamName) → TParam -
inherited
-
moveBy(
int distance) → int -
inherited
-
myDataSources(
int aIndex) → TDataSource -
inherited
-
needLastInsertID(
) → TField? -
inherited
-
needRefreshRecord(
TUpdateKind updateKind) → bool -
inherited
-
newInstance(
TComponent? aOwner) → TCustomSQLQuery -
override
-
next(
) → void -
inherited
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
notification(
TComponent aComponent, TOperation operation) → void -
inherited
-
onChangeModifySQL(
Object sender) → void -
inherited
-
open(
) → void -
inherited
-
openAsync(
) → Future< void> -
Available on TCustomSQLQuery, provided by the TWapSQLQueryAsync extension
@@@ SELECT: prepare → await fetches the whole batch → loads it into the cursor → synchronous open() -
openCursor(
bool infoQuery) → void -
inherited
-
openCursorComplete(
) → void -
inherited
-
paramByName(
String aParamName) → TParam -
inherited
-
post(
) → void -
inherited
-
prepare(
) → void -
inherited
-
prior(
) → void -
inherited
-
psEndTransaction(
bool commit) → void -
inherited
-
psExecute(
) → void -
inherited
-
psExecuteStatement(
String aSQL, TParams aParams, [dynamic resultSet]) → int -
inherited
-
psGetAttributes(
List list) → void -
inherited
-
psGetCommandText(
) → String -
inherited
-
psGetCommandType(
) → TPSCommandType -
inherited
-
psGetDefaultOrder(
) → TIndexDef? -
inherited
-
psGetIndexDefs(
TIndexOptions indexTypes) → TIndexDefs? -
inherited
-
psGetKeyFields(
) → String -
inherited
-
psGetParams(
) → TParams? -
inherited
-
psGetQuoteChar(
) → String -
inherited
-
psGetTableName(
) → String -
inherited
-
psGetUpdateException(
Object e, EUpdateError? prev) → EUpdateError -
inherited
-
psInTransaction(
) → bool -
inherited
-
psIsSQLBased(
) → bool -
inherited
-
psIsSQLSupported(
) → bool -
inherited
-
psReset(
) → void -
inherited
-
psSetCommandText(
String commandText) → void -
inherited
-
psSetParams(
TParams aParams) → void -
inherited
-
psStartTransaction(
) → void -
inherited
-
psUpdateRecord(
TUpdateKind updateKind, TDataSet delta) → bool -
inherited
-
recalcBufListSize(
) → void -
inherited
-
refresh(
) → void -
inherited
-
refreshAsync(
) → Future< void> -
Available on TCustomSQLQuery, provided by the TWapSQLQueryAsync extension
@@@ Closes and reopens (the original Refresh preserves the position near the cursor; this @@@ backend has no cursor, so this is an honest reopen) -
refreshInternalCalcFields(
TRecordBuffer buffer) → void -
inherited
-
refreshLastInsertID(
TField field) → bool -
inherited
-
refreshRecord(
TUpdateKind updateKind) → bool -
inherited
-
registerDataSource(
TDataSource aDataSource) → void -
inherited
-
removeField(
TField field) → void -
inherited
-
removeFreeNotification(
TComponent aComponent) → void -
inherited
-
restoreState(
TDataSetState value) → void -
inherited
-
resync(
TResyncMode mode) → void -
inherited
-
rowsAffected(
) → int -
inherited
-
setBookmarkData(
TRecordBuffer buffer, dynamic data) → void -
inherited
-
setBookmarkFlag(
TRecordBuffer buffer, TBookmarkFlag value) → void -
inherited
-
setBookmarkStr(
TBookmarkStr value) → void -
inherited
-
setBufListSize(
int value) → void -
inherited
-
setChildOrder(
TComponent component, int order) → void -
inherited
-
setCurrentRecord(
int index) → void -
inherited
-
setDataSource(
TDataSource? aValue) → void -
inherited
-
setDefaultFields(
bool value) → void -
inherited
-
setField(
int index, TField value) → void -
inherited
-
setFieldData(
TField field, TValueBuffer? buffer, [bool nativeFormat = true]) → void -
inherited
-
setFieldDataNative(
TField field, TValueBuffer? buffer) → void -
inherited
-
setFields(
List values) → void -
inherited
-
setFieldValues(
String fieldName, dynamic value) → void -
inherited
-
setFound(
bool value) → void -
inherited
-
setModified(
bool value) → void -
inherited
-
setPacketRecords(
int aValue) → void -
inherited
-
setReadOnly(
bool aValue) → void -
inherited
-
setRecNo(
int value) → void -
inherited
-
setSchemaInfo(
TSchemaType aSchemaType, String aSchemaObjectName, String aSchemaPattern) → void -
inherited
-
setServerFiltered(
bool value) → void -
inherited
-
setServerFilterText(
String value) → void -
inherited
-
setState(
TDataSetState value) → void -
inherited
-
setTempState(
TDataSetState value) → TDataSetState -
inherited
-
setUniDirectional(
bool value) → void -
inherited
-
shiftBuffersBackward(
) → void -
inherited
-
shiftBuffersForward(
) → void -
inherited
-
tempBuffer(
) → TRecordBuffer? -
inherited
-
toString(
) → String -
A string representation of this object.
inherited
-
translate(
String src, TStringRef dest, bool toOem) → int -
inherited
-
tryDoing(
TDataOperation p, TDataSetErrorEvent? ev) → bool -
inherited
-
unPrepare(
) → void -
inherited
-
unRegisterDataSource(
TDataSource aDataSource) → void -
inherited
-
updateCursorPos(
) → void -
inherited
-
updateFieldDefs(
) → void -
inherited
-
updateIndexDefs(
) → void -
inherited
-
updateRecord(
) → void -
inherited
-
updateServerIndexDefs(
) → void -
inherited
-
updateStatus(
) → TUpdateStatus -
inherited
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited