TSQLTable Members

The following tables list the members exposed by TSQLTable.

	Name	Description
	FComponentStyle	FComponentStyle is the field of the ComponentStyle read-only property.

Protected Methods

	Name	Description
	_AddRef	Called when an application uses a component interface.
	_Release	Called when an application releases a component interface.
	ActivateBuffers	This is ActivateBuffers, a member of class TDataSet.
	AddFieldDesc	This is AddFieldDesc, a member of class TCustomSQLDataSet.
	AddIndexDefs	This is AddIndexDefs, a member of class TCustomSQLDataSet.
	AllocRecordBuffer	This is AllocRecordBuffer, a member of class TDataSet.
	AssignTo	Copies the properties of an object to a destination object.
	BindFields	This is BindFields, a member of class TDataSet.
	BlockReadNext	This is BlockReadNext, a member of class TDataSet.
	BookmarkAvailable	This is BookmarkAvailable, a member of class TDataSet.
	CalculateFields	This is CalculateFields, a member of class TDataSet.
	ChangeName	Sets the private, internal storage for the Name property to the string passed in NewName.
	CheckActive	This is CheckActive, a member of class TDataSet.
	CheckBiDirectional	This is CheckBiDirectional, a member of class TDataSet.
	CheckFieldCompatibility	This is CheckFieldCompatibility, a member of class TDataSet.
	CheckInactive	This is CheckInactive, a member of class TDataSet.
	CheckPrepareError	This is CheckPrepareError, a member of class TCustomSQLDataSet.
	ClearBuffers	This is ClearBuffers, a member of class TDataSet.
	ClearCalcFields	This is ClearCalcFields, a member of class TDataSet.
	ClearIndexDefs	This is ClearIndexDefs, a member of class TCustomSQLDataSet.
	CloseBlob	This is CloseBlob, a member of class TDataSet.
	CloseCursor	This is CloseCursor, a member of class TDataSet.
	CloseCursor	This is CloseCursor, a member of class TCustomSQLDataSet.
	CloseStatement	This is CloseStatement, a member of class TCustomSQLDataSet.
	CreateFields	This is CreateFields, a member of class TDataSet.
	CreateNestedDataSet	This is CreateNestedDataSet, a member of class TDataSet.
	DataConvert	This is DataConvert, a member of class TDataSet.
	DataEvent	This is DataEvent, a member of class TDataSet.
	DefChanged	This is DefChanged, a member of class TDataSet.
	DefineProperties	Designates methods for storing an object's unpublished data on a stream such as a form file.
	DefineProperties	Provides an interface for a method that reads and writes otherwise unpublished data.
	DefineProperties	Designates methods for storing an object's unpublished data on a stream such as a form file.
	DestroyFields	This is DestroyFields, a member of class TDataSet.
	DoAfterCancel	This is DoAfterCancel, a member of class TDataSet.
	DoAfterClose	This is DoAfterClose, a member of class TDataSet.
	DoAfterDelete	This is DoAfterDelete, a member of class TDataSet.
	DoAfterEdit	This is DoAfterEdit, a member of class TDataSet.
	DoAfterInsert	This is DoAfterInsert, a member of class TDataSet.
	DoAfterOpen	This is DoAfterOpen, a member of class TDataSet.
	DoAfterPost	This is DoAfterPost, a member of class TDataSet.
	DoAfterRefresh	This is DoAfterRefresh, a member of class TDataSet.
	DoAfterScroll	This is DoAfterScroll, a member of class TDataSet.
	DoBeforeCancel	This is DoBeforeCancel, a member of class TDataSet.
	DoBeforeClose	This is DoBeforeClose, a member of class TDataSet.
	DoBeforeDelete	This is DoBeforeDelete, a member of class TDataSet.
	DoBeforeEdit	This is DoBeforeEdit, a member of class TDataSet.
	DoBeforeInsert	This is DoBeforeInsert, a member of class TDataSet.
	DoBeforeOpen	This is DoBeforeOpen, a member of class TDataSet.
	DoBeforePost	This is DoBeforePost, a member of class TDataSet.
	DoBeforeRefresh	This is DoBeforeRefresh, a member of class TDataSet.
	DoBeforeScroll	This is DoBeforeScroll, a member of class TDataSet.
	DoOnCalcFields	This is DoOnCalcFields, a member of class TDataSet.
	DoOnNewRecord	This is DoOnNewRecord, a member of class TDataSet.
	ExecSQL	This is ExecSQL, a member of class TCustomSQLDataSet.
	ExecuteStatement	This is ExecuteStatement, a member of class TCustomSQLDataSet.
	FieldByNumber	This is FieldByNumber, a member of class TDataSet.
	FindRecord	This is FindRecord, a member of class TDataSet.
	FreeBuffers	This is FreeBuffers, a member of class TCustomSQLDataSet.
	FreeCommand	This is FreeCommand, a member of class TCustomSQLDataSet.
	FreeFieldBuffers	This is FreeFieldBuffers, a member of class TDataSet.
	FreeReader	This is FreeReader, a member of class TCustomSQLDataSet.
	FreeRecordBuffer	This is FreeRecordBuffer, a member of class TDataSet.
	GetAggFieldsClass	This is GetAggFieldsClass, a member of class TDataSet.
	GetAggRecordCount	This is GetAggRecordCount, a member of class TDataSet.
	GetAggregateValue	This is GetAggregateValue, a member of class TDataSet.
	GetBookmarkData	This is GetBookmarkData, a member of class TDataSet.
	GetBookmarkFlag	This is GetBookmarkFlag, a member of class TDataSet.
	GetBookmarkStr	This is GetBookmarkStr, a member of class TDataSet.
	GetCalcFields	This is GetCalcFields, a member of class TDataSet.
	GetCanModify	This is GetCanModify, a member of class TDataSet.
	GetCanModify	This is GetCanModify, a member of class TCustomSQLDataSet.
	GetCheckConstraintsClass	This is GetCheckConstraintsClass, a member of class TDataSet.
	GetChildOwner	Returns the owner of a child component being read from a stream.
	GetChildParent	Returns the parent, or if there is no parent, returns the owner of a child component being read from a stream.
	GetChildren	Enumerates all child components.
	GetChildren	Enumerates all child components.
	GetDataSource	This is GetDataSource, a member of class TDataSet.
	GetDataSource	This is GetDataSource, a member of class TCustomSQLDataSet.
	GetFieldClass	This is the overview for the GetFieldClass method overload.
	GetFieldDefListClass	This is GetFieldDefListClass, a member of class TDataSet.
	GetFieldDefsClass	This is GetFieldDefsClass, a member of class TDataSet.
	GetFieldFullName	This is GetFieldFullName, a member of class TDataSet.
	GetFieldListClass	This is GetFieldListClass, a member of class TDataSet.
	GetFieldsClass	This is GetFieldsClass, a member of class TDataSet.
	GetIDsOfNames	Maps a single member and an optional set of argument names to a corresponding set of integer dispatch identifiers (dispIDs).
	GetIndexDefs	This is GetIndexDefs, a member of class TDataSet.
	GetIndexDefsClass	This is GetIndexDefsClass, a member of class TDataSet.
	GetIsIndexField	This is GetIsIndexField, a member of class TDataSet.
	GetLookupListClass	This is GetLookupListClass, a member of class TDataSet.
	GetNextRecord	This is GetNextRecord, a member of class TDataSet.
	GetNextRecords	This is GetNextRecords, a member of class TDataSet.
	GetObjectTypeNames	This is GetObjectTypeNames, a member of class TCustomSQLDataSet.
	GetOutputParams	This is GetOutputParams, a member of class TCustomSQLDataSet.
	GetOwner	Returns the owner of a component.
	GetOwner	Returns the owner of an object.
	GetParamsClass	This is GetParamsClass, a member of class TDataSet.
	GetPriorRecord	This is GetPriorRecord, a member of class TDataSet.
	GetPriorRecords	This is GetPriorRecords, a member of class TDataSet.
	GetRecNo	This is GetRecNo, a member of class TDataSet.
	GetRecord	This is GetRecord, a member of class TDataSet.
	GetRecord	This is GetRecord, a member of class TCustomSQLDataSet.
	GetRecordCount	This is GetRecordCount, a member of class TDataSet.
	GetRecordCount	This is GetRecordCount, a member of class TCustomSQLDataSet.
	GetRecordSize	This is GetRecordSize, a member of class TDataSet.
	GetSortFieldNames	This is GetSortFieldNames, a member of class TCustomSQLDataSet.
	GetStateFieldValue	This is GetStateFieldValue, a member of class TDataSet.
	GetTypeInfo	Retrieves the type information for an object.
	GetTypeInfoCount	Returns the number of type information interfaces that an object provides (either 0 or 1).
	InitFieldDefs	This is InitFieldDefs, a member of class TDataSet.
	InitFieldDefsFromFields	This is InitFieldDefsFromFields, a member of class TDataSet.
	InitRecord	This is InitRecord, a member of class TDataSet.
	InitRecord	This is InitRecord, a member of class TCustomSQLDataSet.
	InternalAddRecord	This is InternalAddRecord, a member of class TDataSet.
	InternalCancel	This is InternalCancel, a member of class TDataSet.
	InternalClose	This is InternalClose, a member of class TDataSet.
	InternalClose	This is InternalClose, a member of class TCustomSQLDataSet.
	InternalDelete	This is InternalDelete, a member of class TDataSet.
	InternalEdit	This is InternalEdit, a member of class TDataSet.
	InternalFirst	This is InternalFirst, a member of class TDataSet.
	InternalFreeCommand	This is InternalFreeCommand, a member of class TCustomSQLDataSet.
	InternalGotoBookmark	This is InternalGotoBookmark, a member of class TDataSet.
	InternalHandleException	This is InternalHandleException, a member of class TDataSet.
	InternalHandleException	This is InternalHandleException, a member of class TCustomSQLDataSet.
	InternalInitFieldDefs	This is InternalInitFieldDefs, a member of class TDataSet.
	InternalInitFieldDefs	This is InternalInitFieldDefs, a member of class TCustomSQLDataSet.
	InternalInitRecord	This is InternalInitRecord, a member of class TDataSet.
	InternalInsert	This is InternalInsert, a member of class TDataSet.
	InternalLast	This is InternalLast, a member of class TDataSet.
	InternalOpen	This is InternalOpen, a member of class TDataSet.
	InternalOpen	This is InternalOpen, a member of class TCustomSQLDataSet.
	InternalPost	This is InternalPost, a member of class TDataSet.
	InternalRefresh	This is InternalRefresh, a member of class TDataSet.
	InternalRefresh	This is InternalRefresh, a member of class TCustomSQLDataSet.
	InternalSetToRecord	This is InternalSetToRecord, a member of class TDataSet.
	Invoke	Provides access to Automation properties and methods when the component wraps an Automation object.
	IsCursorOpen	This is IsCursorOpen, a member of class TDataSet.
	IsCursorOpen	This is IsCursorOpen, a member of class TCustomSQLDataSet.
	Loaded	Initializes the component after the form file has been read into memory.
	Loaded	Initializes the component after the form file has been read into memory.
	Loaded	Initializes the component after the form file has been read into memory.
	LocateRecord	This is LocateRecord, a member of class TCustomSQLDataSet.
	Notification	Forwards notification messages to all owned components.
	OpenCursor	This is OpenCursor, a member of class TSQLTable.
	OpenCursorComplete	This is OpenCursorComplete, a member of class TDataSet.
	OpenParentDataSet	This is OpenParentDataSet, a member of class TDataSet.
	OpenSchema	This is OpenSchema, a member of class TCustomSQLDataSet.
	PaletteCreated	Responds when the component is created from the component palette.
	PropertyChanged	This is PropertyChanged, a member of class TCustomSQLDataSet.
	PSEndTransaction	Ends a transaction that was started by a call to PSStartTransaction.
	PSEndTransaction	Ends a transaction that was started by a call to PSStartTransaction.
	PSExecute	Executes the SQL command associated with the dataset.
	PSExecute	Executes the SQL command associated with the dataset.
	PSExecuteStatement	This is PSExecuteStatement, a member of class TCustomSQLDataSet.
	PSExecuteStatement	This is the overview for the PSExecuteStatement method overload.
	PSExecuteStatement	This is the overview for the PSExecuteStatement method overload.
	PSGetAttributes	Returns information that is stored in data packets as Name/Value pairs.
	PSGetAttributes	Returns information that is stored in data packets as Name/Value pairs.
	PSGetCommandText	Gets the SQL command to be executed by PSExecute.
	PSGetCommandText	Gets the SQL command to be executed by PSExecute.
	PSGetCommandText	Gets the SQL command to be executed by PSExecute.
	PSGetCommandTextW	This is PSGetCommandTextW, a member of class TDataSet.
	PSGetCommandTextW	This is PSGetCommandTextW, a member of class TWideDataSet.
	PSGetCommandType	Gets the command type to be executed by PSExecute.
	PSGetCommandType	Gets the command type to be executed by PSExecute.
	PSGetDefaultOrder	Returns the definition of an index that imposes the default order on the data included in data packets.
	PSGetDefaultOrder	Returns the definition of an index that imposes the default order on the data included in data packets.
	PSGetIndexDefs	Returns the definitions of all specified indexes defined for the dataset.
	PSGetIndexDefs	Returns the definitions of all specified indexes defined for the dataset.
	PSGetKeyFields	Returns the names of all fields required to uniquely identify records in the data packet.
	PSGetKeyFields	Returns the names of all fields required to uniquely identify records in the data packet.
	PSGetKeyFieldsW	This is PSGetKeyFieldsW, a member of class TDataSet.
	PSGetKeyFieldsW	This is PSGetKeyFieldsW, a member of class TWideDataSet.
	PSGetKeyFieldsW	This is PSGetKeyFieldsW, a member of class TCustomSQLDataSet.
	PSGetParams	Returns the current parameter values of the dataset.
	PSGetParams	Returns the current parameter values of the dataset.
	PSGetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
	PSGetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
	PSGetQuoteCharW	This is PSGetQuoteCharW, a member of class TDataSet.
	PSGetQuoteCharW	This is PSGetQuoteCharW, a member of class TWideDataSet.
	PSGetQuoteCharW	This is PSGetQuoteCharW, a member of class TCustomSQLDataSet.
	PSGetTableName	Returns the name of the dataset table that appears in generated SQL statements.
	PSGetTableName	Returns the name of the dataset table that appears in generated SQL statements.
	PSGetTableNameW	This is PSGetTableNameW, a member of class TDataSet.
	PSGetTableNameW	This is PSGetTableNameW, a member of class TWideDataSet.
	PSGetTableNameW	This is PSGetTableNameW, a member of class TCustomSQLDataSet.
	PSGetUpdateException	Generates an EUpdateError object based on another exception object.
	PSGetUpdateException	Generates an EUpdateError object based on another exception object.
	PSInTransaction	Indicates whether actions against the dataset occur in the context of a transaction.
	PSInTransaction	Indicates whether actions against the dataset occur in the context of a transaction.
	PSIsSQLBased	Indicates whether the dataset includes native SQL support.
	PSIsSQLBased	Indicates whether the dataset includes native SQL support.
	PSIsSQLSupported	Indicates whether the dataset can execute SQL statements.
	PSIsSQLSupported	Indicates whether the dataset can execute SQL statements.
	PSReset	Resets the dataset so that it is positioned on the first record.
	PSReset	Resets the dataset so that it is positioned on the first record.
	PSSetCommandText	Assigns a specified SQL command to be executed by PSExecute.
	PSSetCommandText	This is the overview for the PSSetCommandText method overload.
	PSSetCommandText	This is the overview for the PSSetCommandText method overload.
	PSSetParams	Assigns the specified parameter values to the dataset.
	PSSetParams	Assigns the specified parameter values to the dataset.
	PSStartTransaction	Starts a transaction that encapsulates all activity until a call to PSEndTransaction.
	PSStartTransaction	Starts a transaction that encapsulates all activity until a call to PSEndTransaction.
	PSUpdateRecord	Applies a single update to the underlying database table or tables.
	PSUpdateRecord	Applies a single update to the underlying database table or tables.
	QueryInterface	Returns a reference to a specified interface if the object supports that interface.
	ReadState	Reads the state of the component.
	RefreshInternalCalcFields	This is RefreshInternalCalcFields, a member of class TDataSet.
	ResetAggField	This is ResetAggField, a member of class TDataSet.
	RestoreState	This is RestoreState, a member of class TDataSet.
	SetActive	This is SetActive, a member of class TDataSet.
	SetAncestor	Clears or sets csAncestor state in the component's ComponentState property.
	SetBlockReadSize	This is SetBlockReadSize, a member of class TDataSet.
	SetBookmarkData	This is SetBookmarkData, a member of class TDataSet.
	SetBookmarkFlag	This is SetBookmarkFlag, a member of class TDataSet.
	SetBookmarkStr	This is SetBookmarkStr, a member of class TDataSet.
	SetBufListSize	This is SetBufListSize, a member of class TDataSet.
	SetBufListSize	This is SetBufListSize, a member of class TCustomSQLDataSet.
	SetChildOrder	Sets the visual ordering of a child control.
	SetChildOrder	Sets the visual ordering of a child control.
	SetCommandText	This is SetCommandText, a member of class TCustomSQLDataSet.
	SetCurrentRecord	This is SetCurrentRecord, a member of class TDataSet.
	SetDataSetField	This is SetDataSetField, a member of class TDataSet.
	SetDefaultFields	This is SetDefaultFields, a member of class TDataSet.
	SetDesigning	Ensures that components inserted at design time have their design-mode flag set.
	SetDesignInstance	Ensures that components inserted at design time have their design-mode flag set.
	SetFCommandText	This is SetFCommandText, a member of class TCustomSQLDataSet.
	SetFieldData	This is SetFieldData, a member of class TCustomSQLDataSet.
	SetFieldData	This is the overview for the SetFieldData method overload.
	SetFiltered	This is SetFiltered, a member of class TDataSet.
	SetFilterOptions	This is SetFilterOptions, a member of class TDataSet.
	SetFilterText	This is SetFilterText, a member of class TDataSet.
	SetFound	This is SetFound, a member of class TDataSet.
	SetIndexField	This is SetIndexField, a member of class TSQLTable.
	SetInline	Sets the csInline bit of the component's ComponentState property
	SetMaxBlobSize	This is SetMaxBlobSize, a member of class TCustomSQLDataSet.
	SetModified	This is SetModified, a member of class TDataSet.
	SetName	Sets the value of the Name property.
	SetName	Sets the value of the Name property.
	SetObjectView	This is SetObjectView, a member of class TDataSet.
	SetOnFilterRecord	This is SetOnFilterRecord, a member of class TDataSet.
	SetParamsFromCursor	This is SetParamsFromCursor, a member of class TCustomSQLDataSet.
	SetParentComponent	Sets the parent component.
	SetRecNo	This is SetRecNo, a member of class TDataSet.
	SetSortFieldNames	This is SetSortFieldNames, a member of class TCustomSQLDataSet.
	SetState	This is SetState, a member of class TDataSet.
	SetStateFieldValue	This is SetStateFieldValue, a member of class TDataSet.
	SetTempState	This is SetTempState, a member of class TDataSet.
	SetUniDirectional	This is SetUniDirectional, a member of class TDataSet.
	TempBuffer	This is TempBuffer, a member of class TDataSet.
	UpdateBufferCount	This is UpdateBufferCount, a member of class TDataSet.
	Updated	Clears the csUpdating state in the component's ComponentState property when the component finishes updating.
	UpdateIndexDefs	This is UpdateIndexDefs, a member of class TDataSet.
	UpdateIndexDefs	This is UpdateIndexDefs, a member of class TCustomSQLDataSet.
	UpdateRegistry	Provides the interface for a method that adds type library and version information to the Registry on components that implement COM interfaces.
	Updating	Sets the csUpdating state in the component's ComponentState property.
	ValidateContainer	Determines whether an object can be inserted into a container.
	ValidateInsert	Provides the interface for a method that validates an child component before it is inserted.
	ValidateRename	Ensures that renaming an owned component does not create name conflict.
	WriteState	Writes the state of the component.

Protected Properties

	Name	Description
	ActiveRecord	Indicates the index of the active record in the internal cache of records.
	BlobBuffer	Reserves a buffer for storing BLOB values.
	BlobFieldCount	Indicates the number of columns in the dataset that represent Binary large object (BLOB) fields.
	BookmarkSize	Indicates the number of bytes used to represent a bookmark.
	BufferCount	Indicates the number of records in the internal cache.
	Buffers	Provides indexed access to the record buffers in the internal cache.
	CalcBuffer	Points to the record buffer used during an OnCalcFields event.
	CalcFieldsSize	Indicates the number of bytes in a record buffer dedicated to storing calculated fields and lookup fields.
	CommandType	Indicates the meaning of the CommandText property.
	Constraints	Specifies record-level constraints that must be met when editing the data.
	CurrentBlobSize	Indicates the size of the most recently read BLOB field.
	CurrentRecord	Indicates the index of the current record in the internal cache of record buffers.
	DataLink	Identifies the datalink that manages communication between the SQL dataset and another, master dataset.
	DataSource	Links the SQL dataset to another (master) dataset.
	DbxCommandType	This is DbxCommandType, a member of class TCustomSQLDataSet.
	FieldNoOfs	Specifies the offset needed to convert indexes in the Fields property to field numbers.
	InternalCalcFields	Indicates whether the dataset includes internally calculated fields.
	InternalConnection	Indicates the component that connects the dataset to its database server, taking into account whether the connection was cloned.
	MasterLink	This is MasterLink, a member of class TSQLTable.
	NativeCommand	Represents the SQL command that is sent to the server.
	NestedDataSetClass	Indicates the class type to use when creating nested datasets.
	NestedDataSets	Lists all nested datasets.
	ParamCheck	Specifies whether the parameter list for an SQL dataset is regenerated when the SQL command changes.
	ParamCount	Indicates the number of parameters listed by the Params property.
	Params	Represents the parameters for a query or stored procedure.
	ProcParams	ProcParams lists the parameter descriptors obtained from the server for any stored procedure parameters.
	Reserved	For internal use only.
	RowsAffected	Indicates the number of rows operated on by the latest query execution.
	SchemaInfo	Identifies the metadata with which to populate the dataset.
	SortFieldNames	Indicates the sort order when CommandType is ctTable.

Public Events

	Name	Description
	AfterCancel	Occurs after an application completes a request to cancel modifications to the active record.
	AfterClose	Occurs after an application closes a dataset.
	AfterDelete	Occurs after an application deletes a record.
	AfterEdit	Occurs after an application starts editing a record.
	AfterInsert	Occurs after an application inserts a new record.
	AfterOpen	Occurs after an application completes opening a dataset and before any data access occurs.
	AfterPost	Occurs after an application writes the active record to the database or change log and returns to browse state.
	AfterRefresh	Occurs after an application refreshes the data in the dataset.
	AfterScroll	Occurs after an application scrolls from one record to another.
	BeforeCancel	Occurs before an application executes a request to cancel changes to the active record.
	BeforeClose	Occurs immediately before the dataset closes.
	BeforeDelete	Occurs before an application attempts to delete the active record.
	BeforeEdit	Occurs before an application enters edit mode for the active record.
	BeforeInsert	Occurs before an application enters insert mode.
	BeforeOpen	Occurs before an application executes a request to open a dataset.
	BeforePost	Occurs before an application posts changes for the active record to the database or change log.
	BeforeRefresh	Occurs immediately before an application refreshes the data in the dataset.
	BeforeScroll	Occurs before an application scrolls from one record to another.
	OnCalcFields	Occurs when an application recalculates calculated fields.
	OnDeleteError	Occurs when an application attempts to delete a record and an exception is raised.
	OnEditError	Occurs when an application attempts to modify or insert a record and an exception is raised.
	OnFilterRecord	Occurs each time a different record in the dataset becomes the active record and filtering is enabled.
	OnNewRecord	Occurs when an application inserts or appends a new dataset record.
	OnPostError	Occurs when an application attempts to modify or insert a record and an exception is raised.

Public Methods

	Name	Description
	_AddRef	Increments the reference count for this interface.
	_Release	Decrements the reference count for this interface.
	ActiveBuffer	Returns a pointer to the buffer for the active record.
	AfterConstruction	Responds after the last constructor has executed.
	Append	Adds a new, empty record to the end of the dataset.
	AppendRecord	Adds a new, populated record to the end of the dataset and posts it.
	Assign	Copies the contents of another, similar object.
	BeforeDestruction	Performs any necessary actions before the first destructor is called.
	BeforeDestruction	Responds before the first destructor executes.
	BookmarkValid	Indicates the validity of a specified bookmark.
	Cancel	Cancels modifications to the active record if those changes are not yet posted.
	CheckBrowseMode	Automatically posts or cancels data changes when the active record changes.
	ClassInfo	Returns a pointer to the runtime type information (RTTI) table for the object type.
	ClassName	Returns a string indicating the type of the object instance (as opposed to the type of the variable passed as an argument).
	ClassNameIs	Determines whether an object is of a specific type.
	ClassParent	Returns the type of the immediate ancestor of a class.
	ClassType	Returns the class reference for the object's class.
	CleanupInstance	Performs finalization on long strings, variants, and interface variables within a class.
	ClearFields	Clears the contents of all fields for the active record.
	Close	Closes a dataset.
	CompareBookmarks	Implements a virtual function to compare two bookmarks.
	ControlsDisabled	Indicates whether data-aware controls update their display to reflect changes to the dataset.
	CopyFields	This is CopyFields, a member of class TDataSet.
	Create	Creates an instance of a TSQLTable component.
	Create	This is the overview for the Create constructor overload.
	CreateBlobStream	Provides the interface for a method that creates a blob stream for a Binary large object (BLOB) field in the dataset.
	CreateBlobStream	Creates a blob stream for a Binary large object (BLOB) field in the dataset.
	CursorPosChanged	Marks the internal cursor position as invalid.
	DefaultHandler	Provides the interface for a method that processes message records.
	Delete	Deletes the active record and positions the dataset on the next record.
	DeleteRecords	Empties the underlying database table.
	Destroy	Destroys the TSQLTable instance.
	DestroyComponents	Destroys all owned components.
	Destroying	Indicates that the component and its owned components are about to be destroyed.
	DisableControls	Disables data display in data-aware controls associated with the dataset.
	Dispatch	Calls message-handling methods for the object, based on the contents of the Message parameter.
	Edit	Enables editing of data in the dataset.
	EnableControls	Re-enables data display in data-aware controls associated with the dataset.
	Equals	Checks if the current instance and the parameter are equal.
	ExecuteAction	Executes an action.
	FieldAddress	This is the overview for the FieldAddress method overload.
	FieldByName	Finds a field based on its name.
	FindComponent	Indicates whether a given component is owned by the component.
	FindField	Searches for a specified field in the dataset.
	FindFirst	Implements a virtual method for positioning the dataset on the first record, respecting any filters.
	FindLast	Implements a virtual method for positioning the dataset on the last record, respecting any filters.
	FindNext	Implements a virtual method for positioning the dataset on the next record, respecting any filters.
	FindPrior	Implements a virtual method for positioning the dataset on the previous record, respecting any filters.
	First	Moves to the first record in the dataset.
	Free	Destroys an object and frees its associated memory, if necessary.
	FreeBookmark	Frees the resources allocated for a specified bookmark.
	FreeInstance	Deallocates memory allocated by a previous call to the System::TObject::NewInstance method.
	FreeNotification	Ensures that AComponent is notified that the component is going to be destroyed.
	FreeOnRelease	Frees the interface reference for components that were created from COM classes.
	GetBlobFieldData	Reads BLOB data into a buffer.
	GetBlobFieldData	Retrieves the current value of a BLOB field into a buffer.
	GetBookmark	Allocates a bookmark for the active record in the dataset.
	GetCommandNames	This is GetCommandNames, a member of class TCustomSQLDataSet.
	GetComponent	Returns a reference to the component associated by the implementing class.
	GetCurrentRecord	Implements a virtual function to retrieve the current record in a buffer.
	GetDetailDataSets	Fills a list with a dataset for every detail dataset that is not the value of a nested dataset field.
	GetDetailLinkFields	Introduces a method to list the field components that link this dataset as a detail of a master dataset.
	GetDetailLinkFields	Lists the field components that link this dataset as a detail of a master dataset.
	GetEnumerator	Returns a TComponent enumerator.
	GetFieldData	This is the overview for the GetFieldData method overload.
	GetFieldData	This is the overview for the GetFieldData method overload.
	GetFieldList	Retrieves a specified set of field objects into a list.
	GetFieldNames	This is the overview for the GetFieldNames method overload.
	GetHashCode	Returns an integer containing the hash code.
	GetIndexNames	Retrieves a list of available indexes defined for the table.
	GetInterface	Retrieves a specified interface.
	GetInterfaceEntry	Returns the entry for a specific interface implemented in a class.
	GetInterfaceTable	Returns a pointer to a structure containing all of the interfaces implemented by a given class.
	GetKeyFieldNames	This is the overview for the GetKeyFieldNames method overload.
	GetNamePath	Returns a string used by the Object Inspector.
	GetNamePath	Returns the name of the object as it appears in the Object Inspector.
	GetParentComponent	Returns the containing Component.
	GetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
	GotoBookmark	Implements a virtual method to position the dataset on the record to which a specified bookmark points.
	HasParent	Verifies whether the component has a parent.
	InheritsFrom	Determines the relationship of two object types.
	InitInstance	Initializes a newly allocated object instance to all zeros and initializes the instance's virtual method table pointer.
	Insert	Inserts a new, empty record in the dataset.
	InsertComponent	Establishes the component as the owner of a specified component.
	InsertRecord	Inserts a new, populated record to the dataset and posts it.
	InstanceSize	Returns the size in bytes of each instance of the object type.
	IsEmpty	Indicates whether the dataset contains no records.
	IsImplementorOf	Indicates whether the component implements a specified interface.
	IsLinkedTo	Indicates whether a dataset is linked to a specified data source.
	IsSequenced	Indicates whether the underlying database table uses record numbers to indicate the order of records.
	IsSequenced	Indicates whether the dataset can use record numbers to indicate the order of records.
	Last	Moves to the last record in the dataset.
	Locate	Implements a virtual method for searching a dataset for a specified record and making it the active record.
	Locate	Implements a virtual method for searching a dataset for a specified record and making it the active record.
	Lookup	Implements a virtual method to retrieve field values from a record that matches specified search values.
	Lookup	Implements a virtual method to retrieve field values from a record that matches specified search values.
	MethodAddress	This is the overview for the MethodAddress method overload.
	MethodName	Returns the name of a class method by address.
	MoveBy	Moves to another record relative to the active record in the dataset.
	NewInstance	Allocates memory for an instance of an object type and returns a pointer to that new instance.
	Next	Moves to the next record in the dataset.
	Open	Opens the dataset.
	ParamByName	Locates a parameter in the Params property collection.
	Post	Implements a virtual method to write a modified record to the database or change log.
	PrepareStatement	Generates the query that TSQLTable uses to fetch data from the database server.
	Prior	Moves to the previous record in the dataset.
	PSEndTransaction	Ends a transaction that was started by a call to PSStartTransaction.
	PSEndTransaction	Ends a transaction that was started by a call to PSStartTransaction.
	PSExecute	Executes the SQL command associated with the dataset.
	PSExecute	Executes the SQL command associated with the dataset.
	PSExecuteStatement	Executes a specified SQL command.
	PSExecuteStatement	Executes a specified SQL command.
	PSGetAttributes	Returns information that is stored in data packets as Name/Value pairs.
	PSGetAttributes	Returns information that is stored in data packets as Name/Value pairs.
	PSGetCommandText	Gets the SQL command to be executed by PSExecute.
	PSGetCommandText	Gets the SQL command to be executed by PSExecute.
	PSGetCommandType	Gets the command type to be executed by PSExecute.
	PSGetCommandType	Gets the command type to be executed by PSExecute.
	PSGetDefaultOrder	Returns the definition of an index that imposes the default order on the data included in data packets.
	PSGetDefaultOrder	Returns the definition of an index that imposes the default order on the data included in data packets.
	PSGetIndexDefs	Returns the definitions of all specified indexes defined for the dataset.
	PSGetIndexDefs	Returns the definitions of all specified indexes defined for the dataset.
	PSGetKeyFields	Returns the names of all fields required to uniquely identify records in the data packet.
	PSGetKeyFields	Returns the names of all fields required to uniquely identify records in the data packet.
	PSGetParams	Returns the current parameter values of the dataset.
	PSGetParams	Returns the current parameter values of the dataset.
	PSGetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
	PSGetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
	PSGetTableName	Returns the name of the dataset table that appears in generated SQL statements.
	PSGetTableName	Returns the name of the dataset table that appears in generated SQL statements.
	PSGetUpdateException	Generates an EUpdateError object based on another exception object.
	PSGetUpdateException	Generates an EUpdateError object based on another exception object.
	PSInTransaction	Indicates whether actions against the dataset occur in the context of a transaction.
	PSInTransaction	Indicates whether actions against the dataset occur in the context of a transaction.
	PSIsSQLBased	Indicates whether the dataset includes native SQL support.
	PSIsSQLBased	Indicates whether the dataset includes native SQL support.
	PSIsSQLSupported	Indicates whether the dataset can execute SQL statements.
	PSIsSQLSupported	Indicates whether the dataset can execute SQL statements.
	PSReset	Resets the dataset so that it is positioned on the first record.
	PSReset	Resets the dataset so that it is positioned on the first record.
	PSSetCommandText	Assigns a specified SQL command to be executed by PSExecute.
	PSSetCommandText	Assigns a specified SQL command to be executed by PSExecute.
	PSSetParams	Assigns the specified parameter values to the dataset.
	PSSetParams	Assigns the specified parameter values to the dataset.
	PSStartTransaction	Starts a transaction that encapsulates all activity until a call to PSEndTransaction.
	PSStartTransaction	Starts a transaction that encapsulates all activity until a call to PSEndTransaction.
	PSUpdateRecord	Applies a single update to the underlying database table or tables.
	PSUpdateRecord	Applies a single update to the underlying database table or tables.
	QueryInterface	Returns a reference to a specified interface if the object supports that interface.
	ReferenceInterface	Establishes or removes internal links that cause this component to be notified when the implementer of a specified interface is destroyed.
	Refresh	Re-fetches data from the database to update a dataset's view of data.
	RemoveComponent	Removes a specified component specified from the component's Components list.
	RemoveFreeNotification	Disables destruction notification that was enabled by FreeNotification
	Resync	Re-fetches the active record and the records that precede and follow it.
	SafeCallException	Handles exceptions in methods declared using the safecall calling convention.
	SafeCallException	Handles exceptions in methods declared using the safecall calling convention.
	SetFields	Sets the values for all fields in a record
	SetSchemaInfo	Indicates whether the dataset represents metadata from the server, and if so, what kind.
	SetSubComponent	Identifies whether the component is a subcomponent.
	ToString	Returns a string containing the class name.
	Translate	Implements a virtual procedure to copy a data string from a source to a destination, optionally performing character translation during the copy.
	UnitName	Returns a string containing the unit name.
	UpdateAction	Updates the state of an action.
	UpdateCursorPos	Positions the cursor on the active record.
	UpdateRecord	Ensures that data-aware controls and detail datasets reflect record updates.
	UpdateStatus	Reports the update status for the active record.

Public Properties

	Name	Description
	AggFields	Contains any aggregate fields.
	AutoCalcFields	Determines when the OnCalcFields event is triggered and when lookup field values are calculated.
	BlockReadSize	Determines how many record buffers are read in each block.
	Bof	Indicates whether the first record in the dataset is active.
	Bookmark	Specifies the current bookmark in the dataset.
	CanModify	Indicates whether the dataset permits write access to data.
	CommandText	Specifies the command the dataset executes.
	ComObject	Specifies the interface reference implemented by the component.
	ComponentCount	Indicates the number of components owned by the component.
	ComponentIndex	Indicates the position of the component in its owner's Components property array.
	Components	Lists all components owned by the component.
	ComponentState	Describes the current state of the component, indicating when a component needs to avoid certain actions.
	ComponentStyle	Governs the behavior of the component.
	DataSetField	Indicates the persistent TDataSetField object that owns a nested dataset.
	DataSource	Represents the data source of another dataset that supplies values to the dataset.
	DefaultFields	Indicates whether a dataset's underlying field components are generated dynamically when the dataset is opened.
	Designer	Returns a pointer to the DataSet designer for the dataset.
	DesignerData	Stores custom data.
	DesignInfo	Contains information used by the Form designer.
	Eof	Indicates whether a dataset is positioned at the last record.
	FieldCount	Indicates the number of field components associated with the dataset.
	FieldDefList	Points to the list of field definitions for the dataset.
	FieldDefs	Points to the list of field definitions for the dataset.
	FieldList	Lists the field components of a dataset.
	Fields	Lists all non-aggregate field components of the dataset.
	FieldValues	Provides access to the values for all fields in the active record for the dataset
	Filter	Specifies the text of the current filter for a dataset.
	Filtered	Specifies whether or not filtering is active for a dataset.
	FilterOptions	Specifies whether or not filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records.
	Found	Indicates whether or not moving to a different record is successful.
	IndexDefs	Contains the definitions of all indexes defined on the server for the dataset.
	IndexFieldCount	Indicates the number of fields that make up the current index.
	IndexFields	Specifies the fields associated with the current index.
	IsUniDirectional	Indicates whether the dataset is unidirectional.
	Modified	Indicates whether the active record is modified.
	ObjectView	Specifies whether fields are stored hierarchically or flattened out in the Fields property.
	Owner	Indicates the component that is responsible for streaming and freeing this component.
	Prepared	Specifies whether the command is prepared before execution.
	RecNo	Indicates the active record in the dataset.
	RecordCount	Indicates the total number of records associated with the dataset.
	RecordCount	Indicates the total number of records associated with the dataset.
	RecordSize	Indicates the size of a record in the dataset.
	SparseArrays	Determines whether a unique TField object is created for each element of an array field.
	State	Indicates the current operating mode of the dataset.
	TransactionLevel	Indicates the transaction to which this dataset belongs.
	VCLComObject	Represents information used internally by components that support COM.

Published Events

	Name	Description
	AfterClose	Occurs after a data source connection is closed.
	AfterOpen	Occurs after the connection to a data source is opened.
	AfterRefresh	Occurs after a DataSet has been changed and is refreshed.
	AfterScroll	Occurs after a result set is scrolled.
	BeforeClose	Occurs just before a data connection is closed.
	BeforeOpen	Occurs just before a data connection is opened, but after an open operation has been initiated.
	BeforeRefresh	Occurs before a DataSet refresh occurs.
	BeforeScroll	Occurs when a DataSet scroll operation has been initiated but before the scrolling actually takes place.
	OnCalcFields	Occurs when calculated or derived fields are updated.
	ParseDeleteSql	Occurs when an application attempts to parse the DELETE statement stored in the CommandText property.
	ParseInsertSql	Occurs when an application attempts to parse the INSERT statement stored in the CommandText property.
	ParseSelectSql	Occurs when an application attempts to parse the SELECT statement specified in the CommandText property.
	ParseUpdateSql	Occurs when an application attempts to parse a SQL UPDATE statement stored in the CommandText property.

Published Properties

	Name	Description
	Active	Specifies whether or not a dataset is open.
	GetMetadata	Specifies whether the SQL dataset fetches metadata information along with the data.
	IndexFieldNames	Lists the fields to use for sorting records and for linking in master/detail relationships.
	IndexName	Identifies an index to use for sorting records and for linking the table as the detail of a master/detail relationship.
	MasterFields	Identifies the fields from the master dataset to use for linking this table as the detail of a master/detail relationship.
	MasterSource	Identifies the master dataset to use when linking this table as the detail of a master/detail relationship.
	MaxBlobSize	Indicates the maximum number of bytes fetched for any BLOB field in the dataset.
	Name	Specifies the name of the component as referenced in code.
	NumericMapping	Maps fldBCD to either ftFMTBCD or ftBCD field types.
	ObjectView	Specifies whether fields are stored hierarchically or flattened out in the Fields property.
	SchemaName	Specifies the name of the database schema.
	SQLConnection	Specifies the SQL connection component that connects the dataset to a database server.
	TableName	Specifies the table on the database server represented by this component.
	Tag	Stores an integer value as part of a component.

What do you think about this topic? Send feedback!