Data.SqlExpr.TCustomSQLDataSet Declared Members

• Up to Parent: TCustomSQLDataSet

Constructors & Destructors

Create	Creates an instance of a TCustomSQLDataSet component.
Destroy	Destroys the TCustomSQLDataSet instance.

Events

AfterClose
AfterOpen
AfterRefresh
AfterScroll
BeforeClose
BeforeOpen
BeforeRefresh
BeforeScroll
OnCalcFields
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.

Functions

AddFieldDesc
AddIndexDefs
CheckPrepareError
ClearIndexDefs
CloseCursor
CloseStatement
CreateBlobStream	Creates a blob stream for a Binary large object (BLOB) field in the dataset.
DefineProperties
ExecSQL
ExecuteStatement
FreeBuffers
FreeCommand
FreeReader
GetBlobFieldData	Retrieves the current value of a BLOB field into a buffer.
GetCanModify
GetCommandNames
GetDataSource
GetDetailLinkFields	Lists the field components that link this dataset as a detail of a master dataset.
GetFieldData	Retrieves the current value of a field into a buffer.
GetKeyFieldNames	Fills a list with the names of all fields in all indexes defined for the dataset.
GetObjectTypeNames
GetOutputParams
GetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
GetRecord
GetRecordCount
GetSortFieldNames
InitRecord
InternalClose
InternalFreeCommand
InternalHandleException
InternalInitFieldDefs
InternalOpen
InternalRefresh
IsCursorOpen
IsSequenced	Indicates whether the dataset can use record numbers to indicate the order of records.
Loaded
Locate	Implements a virtual method for searching a dataset for a specified record and making it the active record.
LocateRecord	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.
OpenCursor
OpenSchema
ParamByName	Locates a parameter in the Params property collection.
PrepareStatement	Performs a prepare on the SQL statement.
PropertyChanged
PSEndTransaction
PSExecute
PSExecuteStatement
PSGetAttributes
PSGetCommandText
PSGetCommandType
PSGetDefaultOrder
PSGetIndexDefs
PSGetKeyFieldsW
PSGetParams
PSGetQuoteCharW
PSGetTableNameW
PSGetUpdateException
PSInTransaction
PSIsSQLBased
PSIsSQLSupported
PSReset
PSSetCommandText
PSSetParams
PSStartTransaction
PSUpdateRecord
SetBufListSize
SetCommandText
SetFCommandText
SetFieldData
SetMaxBlobSize
SetParamsFromCursor
SetSchemaInfo	Indicates whether the dataset represents metadata from the server, and if so, what kind.
SetSortFieldNames
UpdateIndexDefs

Properties

Active
BlobBuffer	Reserves a buffer for storing BLOB values.
CommandText	Specifies the command the dataset executes.
CommandType	Indicates the meaning of the CommandText property.
CurrentBlobSize	Indicates the size of the most recently read BLOB field.
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	Command type in String format.
DesignerData	Stores custom data.
GetMetadata	Specifies whether the SQL dataset fetches metadata information along with the data.
IndexDefs	Contains the definitions of all indexes defined on the server for the dataset.
InternalConnection	Indicates the component that connects the dataset to its database server, taking into account whether the connection was cloned.
MaxBlobSize	Indicates the maximum number of bytes fetched for any BLOB field in the dataset.
NativeCommand	Represents the SQL command that is sent to the server.
NumericMapping	Maps fldBCD to either ftFMTBCD or ftBCD field types.
ObjectView
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.
Prepared	Specifies whether the command is prepared before execution.
ProcParams	ProcParams lists the parameter descriptors obtained from the server for any stored procedure parameters.
RecordCount	Indicates the total number of records associated with the dataset.
RowsAffected	Indicates the number of rows operated on by the latest query execution.
SchemaInfo	Identifies the metadata with which to populate the dataset.
SchemaName	Specifies the name of the database schema.
SortFieldNames	Indicates the sort order when CommandType is ctTable.
SQLConnection	Specifies the SQL connection component that connects the dataset to a database server.