TIBStoredProc Members

The following tables list the members exposed by TIBStoredProc.

	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 TIBStoredProc.
	Disconnect	This is Disconnect, a member of class TIBStoredProc.
	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.
	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 TIBStoredProc.
	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.
	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 TIBStoredProc.
	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 TIBStoredProc.
	PSExecuteStatement	This is PSExecuteStatement, a member of class TIBCustomDataSet.
	PSGetParams	This is PSGetParams, a member of class TIBStoredProc.
	PSGetQuoteChar	This is PSGetQuoteChar, a member of class TIBCustomDataSet.
	PSGetTableName	This is PSGetTableName, a member of class TIBStoredProc.
	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 TIBStoredProc.
	PSSetParams	This is PSSetParams, a member of class TIBStoredProc.
	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 TIBStoredProc.
	SetPrepare	This is SetPrepare, a member of class TIBStoredProc.
	SetPrepared	This is SetPrepared, a member of class TIBStoredProc.
	SetProcName	This is SetProcName, a member of class TIBStoredProc.
	SetRecNo	This is SetRecNo, a member of class TIBCustomDataSet.

Protected Properties

	Name	Description
	BufferChunks	Specifies the dataset buffer chunk size.
	CachedUpdates	Specifies whether cached updates are enabled for a dataset.
	DeleteSQL	Holds the SQL statement used to delete rows from the dataset.
	GeneratorField	Specifies whether the dataset should refresh its data every time it posts a record.
	InsertSQL	Holds the SQL statement used to insert rows into the dataset.
	InternalPrepared	Indicates whether the dataset has prepared its queries for execution.
	LiveMode	Indicates what types of edits, if any, can be made to the data in the dataset.
	ModifySQL	Provides the ability to access the SQL object encapsulating the ModifySQL statement.
	ParamCheck	Specifies whether the parameter list for a query is regenerated if the SQL property changes at runtime.
	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.
	StatementType	Returns the statement type of the QSelect query.
	UniDirectional	Determines whether bidirectional cursors are enabled for the dataset.
	UpdateMode	Indicates how records are located when updating records.

Public Methods

	Name	Description
	ApplyUpdates	Writes a dataset's pending cached updates to the database.
	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.
	CopyParams	Copies a stored procedure's parameters into another parameter list.
	Create	Creates an instance of a stored procedure 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 stored procedure.
	ExecProc	Executes the stored procedure on the server.
	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.
	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	Prepares a stored procedure for 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 stored procedure.
	UpdateStatus	Reports the update status for the current record.

Public Properties

	Name	Description
	DBHandle	Specifies the database handle for the dataset.
	ParamCount	Indicates the number of parameters for the stored procedure component.
	Plan	Indicates the PLAN portion of the dataset's SELECT query.
	Prepared	Determines whether or not a stored procedure is prepared for execution.
	RowsAffected	Indicates the number of rows operated on by the latest query execution.
	StmtHandle	Identifies the statement handle for the stored procedure.
	StoredProcedureNames	Returns a list of stored procedures in the database.
	TRHandle	Specifies the transaction handle for the dataset.
	UpdateObject	Specifies the update object component used to update a read-only result set.
	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
	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.
	Database	Identifies the database component for which this dataset represents one or more tables.
	Filtered	Specifies whether filtering is active for a dataset.
	ForcedRefresh	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 TIBStoredProc.
	OnNewRecord	This is OnNewRecord, a member of class TIBCustomDataSet.
	OnPostError	This is OnPostError, a member of class TIBCustomDataSet.
	Params	Stores the input and output parameters for a stored procedure.
	StoredProcName	Identifies the name of the stored procedure on the server for which this object is an encapsulation.
	Transaction	Identifies the transaction under which the query executes.

What do you think about this topic? Send feedback!