TIBQuery Members

The following tables list the members exposed by TIBQuery.

	Name	Description
	ActivateConnection	This is ActivateConnection, a member of class TIBCustomDataSet.
	ActivateTransaction	This is ActivateTransaction, a member of class TIBCustomDataSet.
	AllocRecordBuffer	This is AllocRecordBuffer, a member of class TIBCustomDataSet.
	CheckDatasetClosed	This is CheckDatasetClosed, a member of class TIBCustomDataSet.
	CheckDatasetOpen	This is CheckDatasetOpen, a member of class TIBCustomDataSet.
	CheckNotUniDirectional	This is CheckNotUniDirectional, a member of class TIBCustomDataSet.
	ClearCalcFields	This is ClearCalcFields, a member of class TIBCustomDataSet.
	ConstraintsStored	This is ConstraintsStored, a member of class TIBCustomDataSet.
	CreateFields	This is CreateFields, a member of class TIBCustomDataSet.
	DeactivateTransaction	This is DeactivateTransaction, a member of class TIBCustomDataSet.
	DefineProperties	This is DefineProperties, a member of class TIBQuery.
	Disconnect	This is Disconnect, a member of class TIBQuery.
	DoBeforeDelete	This is DoBeforeDelete, a member of class TIBCustomDataSet.
	DoBeforeEdit	This is DoBeforeEdit, a member of class TIBCustomDataSet.
	DoBeforeInsert	This is DoBeforeInsert, a member of class TIBCustomDataSet.
	DoOnNewRecord	This is DoOnNewRecord, a member of class TIBCustomDataSet.
	FreeRecordBuffer	This is FreeRecordBuffer, a member of class TIBCustomDataSet.
	GenerateQueryForLiveUpdate	This is GenerateQueryForLiveUpdate, a member of class TIBQuery.
	GetActiveBuf	This is GetActiveBuf, a member of class TIBCustomDataSet.
	GetBookmarkData	This is GetBookmarkData, a member of class TIBCustomDataSet.
	GetBookmarkFlag	This is GetBookmarkFlag, a member of class TIBCustomDataSet.
	GetCanModify	This is GetCanModify, a member of class TIBCustomDataSet.
	GetDataSource	This is GetDataSource, a member of class TIBCustomDataSet.
	GetFieldClass	This is GetFieldClass, a member of class TIBCustomDataSet.
	GetParamsCount	This is GetParamsCount, a member of class TIBQuery.
	GetRecNo	This is GetRecNo, a member of class TIBCustomDataSet.
	GetRecord	This is GetRecord, a member of class TIBCustomDataSet.
	GetRecordCount	This is GetRecordCount, a member of class TIBCustomDataSet.
	GetRecordSize	This is GetRecordSize, a member of class TIBCustomDataSet.
	InitFieldDefs	This is InitFieldDefs, a member of class TIBQuery.
	InitRecord	This is InitRecord, a member of class TIBCustomDataSet.
	InternalAddRecord	This is InternalAddRecord, a member of class TIBCustomDataSet.
	InternalBatchInput	This is InternalBatchInput, a member of class TIBCustomDataSet.
	InternalBatchOutput	This is InternalBatchOutput, a member of class TIBCustomDataSet.
	InternalCancel	This is InternalCancel, a member of class TIBCustomDataSet.
	InternalClose	This is InternalClose, a member of class TIBCustomDataSet.
	InternalDelete	This is InternalDelete, a member of class TIBCustomDataSet.
	InternalExecQuery	This is InternalExecQuery, a member of class TIBCustomDataSet.
	InternalFirst	This is InternalFirst, a member of class TIBCustomDataSet.
	InternalGotoBookmark	This is InternalGotoBookmark, a member of class TIBCustomDataSet.
	InternalHandleException	This is InternalHandleException, a member of class TIBCustomDataSet.
	InternalInitFieldDefs	This is InternalInitFieldDefs, a member of class TIBCustomDataSet.
	InternalInitRecord	This is InternalInitRecord, a member of class TIBCustomDataSet.
	InternalInsert	This is InternalInsert, a member of class TIBCustomDataSet.
	InternalLast	This is InternalLast, a member of class TIBCustomDataSet.
	InternalOpen	This is InternalOpen, a member of class TIBQuery.
	InternalPost	This is InternalPost, a member of class TIBCustomDataSet.
	InternalPrepare	This is InternalPrepare, a member of class TIBCustomDataSet.
	InternalRefresh	This is InternalRefresh, a member of class TIBCustomDataSet.
	InternalRefreshRow	This is InternalRefreshRow, a member of class TIBCustomDataSet.
	InternalSetParamsFromCursor	This is InternalSetParamsFromCursor, a member of class TIBCustomDataSet.
	InternalSetToRecord	This is InternalSetToRecord, a member of class TIBCustomDataSet.
	InternalUnPrepare	This is InternalUnPrepare, a member of class TIBCustomDataSet.
	IsCursorOpen	This is IsCursorOpen, a member of class TIBCustomDataSet.
	Loaded	This is Loaded, a member of class TIBCustomDataSet.
	PSEndTransaction	This is PSEndTransaction, a member of class TIBCustomDataSet.
	PSExecute	This is PSExecute, a member of class TIBQuery.
	PSExecuteStatement	This is PSExecuteStatement, a member of class TIBCustomDataSet.
	PSGetParams	This is PSGetParams, a member of class TIBQuery.
	PSGetQuoteChar	This is PSGetQuoteChar, a member of class TIBCustomDataSet.
	PSGetTableName	This is PSGetTableName, a member of class TIBQuery.
	PSGetUpdateException	This is PSGetUpdateException, a member of class TIBCustomDataSet.
	PSInTransaction	This is PSInTransaction, a member of class TIBCustomDataSet.
	PSIsSQLBased	This is PSIsSQLBased, a member of class TIBCustomDataSet.
	PSIsSQLSupported	This is PSIsSQLSupported, a member of class TIBCustomDataSet.
	PSReset	This is PSReset, a member of class TIBCustomDataSet.
	PSSetCommandText	This is PSSetCommandText, a member of class TIBQuery.
	PSSetParams	This is PSSetParams, a member of class TIBQuery.
	PSStartTransaction	This is PSStartTransaction, a member of class TIBCustomDataSet.
	PSUpdateRecord	This is PSUpdateRecord, a member of class TIBCustomDataSet.
	ReQuery	This is ReQuery, a member of class TIBCustomDataSet.
	SetActive	This is SetActive, a member of class TIBCustomDataSet.
	SetBookmarkData	This is SetBookmarkData, a member of class TIBCustomDataSet.
	SetBookmarkFlag	This is SetBookmarkFlag, a member of class TIBCustomDataSet.
	SetCachedUpdates	This is SetCachedUpdates, a member of class TIBCustomDataSet.
	SetDataSource	This is SetDataSource, a member of class TIBCustomDataSet.
	SetFieldData	This is the overview for the SetFieldData method overload.
	SetFiltered	This is SetFiltered, a member of class TIBQuery.
	SetRecNo	This is SetRecNo, a member of class TIBCustomDataSet.

Protected Properties

	Name	Description
	DeleteSQL	Holds the SQL statement used to delete rows from the dataset.
	InsertSQL	Holds the SQL statement used to insert rows into the dataset.
	InternalPrepared	Indicates whether the dataset has prepared its queries for execution.
	ModifySQL	Provides the ability to access the SQL object encapsulating the ModifySQL statement.
	QDelete	Provides the ability to directly access the SQL object encapsulating the DeleteSQL statement.
	QInsert	Provides the ability to directly access the SQL object encapsulating the InsertSQL statement.
	QModify	Provides the ability to directly access the SQL object encapsulating the ModifySQL statement.
	QRefresh	Provides the ability to directly access the SQL object encapsulating the RefreshSQL statement.
	QSelect	Provides the ability to directly access the SQL object encapsulating the SelectSQL statement.
	RefreshSQL	Provides the ability to directly access the SQL object encapsulating the RefreshSQL statement.
	SelectSQL	Provides the ability to directly access the SQL object encapsulating the SelectSQL statement.
	SelectStmtHandle	Gets the handle for the SELECT statement.
	SQLParams	Specifies the parameters to use for any parameterized queries.
	UpdateMode	Indicates how records are located when updating records.

Public Methods

	Name	Description
	ApplyUpdates	Writes a dataset's pending cached updates to the database.
	BatchInput	Executes the parameterized query in SQL for input in the referenced input object.
	BatchOutput	Outputs the selected query in SQL to the referenced OutputObject.
	BookmarkValid	Indicates the validity of a specified bookmark.
	CachedUpdateStatus	Returns the status of the cached updates.
	CancelUpdates	Clears all pending cached updates from the cache.
	CompareBookmarks	Compares two bookmarks.
	Create	Creates an instance of a query component.
	CreateBlobStream	Returns a TIBDSBlobStream object for reading or writing the data in a specified blob field.
	Current	Returns the descriptor area that holds information about the current query.
	Destroy	Destroys the instance of a query.
	ExecSQL	Executes the SQL statement for the query.
	FetchAll	Retrieves all records from the current cursor position to the end of the file and stores them locally.
	GetCurrentRecord	Retrieves the current record into a buffer.
	GetDetailLinkFields	Fills lists with the master and detail fields of the link.
	GetFieldData	This is the overview for the GetFieldData method overload.
	IsSequenced	IsSequenced indicates whether sequence numbers are available for database records.
	Locate	Searches the dataset for a specified record and makes that record the current record.
	LocateNext	Searches the dataset for the record after a specified record and makes that record the current record.
	Lookup	Retrieves field values from a record that matches specified search values.
	ParamByName	Accesses parameter information based on a specified parameter name.
	Post	Writes a modified record to the database server.
	Prepare	Sends a query to the server for optimization prior to execution.
	RecordModified	Sets the record to modified or unmodified.
	RevertRecord	Restores the current record in the dataset to an unmodified state when cached updates are enabled.
	SQLType	Returns the type of query to be executed.
	Undelete	Restores a record deleted from the dataset.
	UnPrepare	Frees the resources allocated for a previously prepared query.
	UpdateStatus	Reports the update status for the current record.

Public Properties

	Name	Description
	DBHandle	Specifies the database handle for the dataset.
	GenerateParamNames	Generates a list of parameter names for the query.
	LiveMode	Indicates what types of edits, if any, can be made to the data in the dataset.
	ParamCount	Indicates the current number of parameters for the query.
	Plan	Indicates the PLAN portion of the dataset's SELECT query.
	Prepared	Determines whether or not a query is prepared for execution.
	RowsAffected	Returns the number of rows operated upon by the latest query execution.
	StatementType	Returns the statement type of the QSelect query.
	StmtHandle	Identifies the statement handle for the query.
	Text	Points to the actual text of the SQL query.
	TRHandle	Specifies the transaction handle for the dataset.
	UpdateRecordTypes	Specifies the type of records visible in a dataset when cached updates are enabled.
	UpdatesPending	Indicates whether the cached updates buffer contains records that are not yet applied.

Published Events

	Name	Description
	AfterDatabaseDisconnect	Occurs immediately after the connection to the associated database is closed.
	AfterTransactionEnd	Occurs immediately after a transaction that includes this dataset's query ends.
	BeforeDatabaseDisconnect	Occurs immediately before the connection to the associated database is closed.
	BeforeTransactionEnd	Occurs immediately before a transaction that includes this dataset's query ends.
	DatabaseFree	Occurs when the database associated with this dataset is freed.
	OnUpdateError	Occurs if an exception is generated when cached updates are applied to a database.
	OnUpdateRecord	Occurs when cached updates are applied to a record.
	TransactionFree	Occurs when the transaction that includes this dataset's query is freed.

Published Properties

	Name	Description
	Active	This is Active, a member of class TIBQuery.
	AfterCancel	This is AfterCancel, a member of class TIBCustomDataSet.
	AfterClose	This is AfterClose, a member of class TIBCustomDataSet.
	AfterDelete	This is AfterDelete, a member of class TIBCustomDataSet.
	AfterEdit	This is AfterEdit, a member of class TIBCustomDataSet.
	AfterInsert	This is AfterInsert, a member of class TIBCustomDataSet.
	AfterOpen	This is AfterOpen, a member of class TIBCustomDataSet.
	AfterPost	This is AfterPost, a member of class TIBCustomDataSet.
	AfterRefresh	This is AfterRefresh, a member of class TIBCustomDataSet.
	AfterScroll	This is AfterScroll, a member of class TIBCustomDataSet.
	AutoCalcFields	This is AutoCalcFields, a member of class TIBCustomDataSet.
	BeforeCancel	This is BeforeCancel, a member of class TIBCustomDataSet.
	BeforeClose	This is BeforeClose, a member of class TIBCustomDataSet.
	BeforeDelete	This is BeforeDelete, a member of class TIBCustomDataSet.
	BeforeEdit	This is BeforeEdit, a member of class TIBCustomDataSet.
	BeforeInsert	This is BeforeInsert, a member of class TIBCustomDataSet.
	BeforeOpen	This is BeforeOpen, a member of class TIBCustomDataSet.
	BeforePost	This is BeforePost, a member of class TIBCustomDataSet.
	BeforeRefresh	This is BeforeRefresh, a member of class TIBCustomDataSet.
	BeforeScroll	This is BeforeScroll, a member of class TIBCustomDataSet.
	BufferChunks	Specifies the dataset buffer chunk size.
	CachedUpdates	Specifies whether cached updates are enabled for a dataset.
	Constraints	This is Constraints, a member of class TIBQuery.
	Database	Identifies the database component for which this dataset represents one or more tables.
	DataSource	This is DataSource, a member of class TIBQuery.
	Filtered	Specifies whether filtering is active for a dataset.
	ForcedRefresh	Specifies whether the dataset should refresh its data every time it posts a record.
	GeneratorField	Specifies whether the dataset should refresh its data every time it posts a record.
	ObjectView	This is ObjectView, a member of class TIBCustomDataSet.
	OnCalcFields	This is OnCalcFields, a member of class TIBCustomDataSet.
	OnDeleteError	This is OnDeleteError, a member of class TIBCustomDataSet.
	OnEditError	This is OnEditError, a member of class TIBCustomDataSet.
	OnFilterRecord	This is OnFilterRecord, a member of class TIBQuery.
	OnNewRecord	This is OnNewRecord, a member of class TIBCustomDataSet.
	OnPostError	This is OnPostError, a member of class TIBCustomDataSet.
	ParamCheck	Specifies whether the parameter list for a query is regenerated if the SQL property changes at runtime.
	Params	Contains the parameters for a query's SQL statement.
	SQL	Contains the text of the SQL statement to execute for the query.
	Transaction	Identifies the transaction under which the query executes.
	UniDirectional	Determines whether bidirectional cursors are enabled for the dataset.
	UpdateObject	Specifies the update object component used to update a read-only result set.

What do you think about this topic? Send feedback!