Data.SqlExpr.TSqlServerMethod Properties
InheritedProtected
Active | published | Specifies whether or not a dataset is open. |
ActiveRecord | protected | Indicates the index of the active record in the internal cache of records. |
AfterClose | published | Occurs after an application closes a dataset. |
AfterOpen | published | Occurs after an application completes opening a dataset and before any data access occurs. |
AfterRefresh | published | Occurs after an application refreshes the data in the dataset. |
AfterScroll | published | Occurs after an application scrolls from one record to another. |
AggFields | public | Contains any aggregate fields. |
AutoCalcFields | public | Determines when the OnCalcFields event is triggered and when lookup field values are calculated. |
BeforeClose | published | Occurs immediately before the dataset closes. |
BeforeOpen | published | Occurs before an application executes a request to open a dataset. |
BeforeRefresh | published | Occurs immediately before an application refreshes the data in the dataset. |
BeforeScroll | published | Occurs before an application scrolls from one record to another. |
BlobBuffer | protected | Reserves a buffer for storing BLOB values. |
BlobFieldCount | protected | Indicates the number of columns in the dataset that represent Binary large object (BLOB) fields. |
BlockReadSize | public | Determines how many record buffers are read in each block. |
Bof | public | Indicates whether the first record in the dataset is active. |
Bookmark | public | Specifies the current bookmark in the dataset. |
BookmarkSize | protected | Indicates the number of bytes used to represent a bookmark. |
BufferCount | protected | Indicates the number of records in the internal cache. |
Buffers | protected | Provides indexed access to the record buffers in the internal cache. |
CalcBuffer | protected | Points to the record buffer used during an OnCalcFields event. |
CalcFieldsSize | protected | Indicates the number of bytes in a record buffer dedicated to storing calculated fields and lookup fields. |
CanModify | public | Indicates whether the dataset permits write access to data. |
CanRefresh | public | |
CommandText | public | Specifies the command the dataset executes. |
CommandType | protected | Indicates the meaning of the CommandText property. |
ComObject | public | Specifies the interface reference implemented by the component. |
ComponentCount | public | Indicates the number of components owned by the component. |
ComponentIndex | public | Indicates the position of the component in its owner's Components property array. |
Components | public | Lists all components owned by the component. |
ComponentState | public | Describes the current state of the component, indicating when a component needs to avoid certain actions. |
ComponentStyle | public | Governs the behavior of the component. |
Constraints | protected | Specifies record-level constraints that must be met when editing the data. |
CurrentBlobSize | protected | Indicates the size of the most recently read BLOB field. |
CurrentRecord | protected | Indicates the index of the current record in the internal cache of record buffers. |
DataLink | protected | Identifies the datalink that manages communication between the SQL dataset and another, master dataset. |
DataSetField | public | Indicates the persistent TDataSetField object that owns a nested dataset. |
DataSource | protected | Links the SQL dataset to another (master) dataset. |
DbxCommandType | protected | Command type in String format. |
Designer | public | Returns a pointer to the DataSet designer for the dataset. |
DesignerData | public | Stores custom data. |
DesignInfo | public | Contains information used by the Form designer. |
Disposed | protected | Disposed is a read-only property that shows the current state of this object. |
Eof | public | Indicates whether a dataset is positioned at the last record. |
FieldCount | public | Indicates the number of field components associated with the dataset. |
FieldDefList | public | Points to the list of field definitions for the dataset. |
FieldDefs | public | Points to the list of field definitions for the dataset. |
FieldList | public | Lists the field components of a dataset. |
FieldNoOfs | protected | Specifies the offset needed to convert indexes in the Fields property to field numbers. |
FieldOptions | protected | Specifies the options of the dataset fields. |
Fields | public | Lists all non-aggregate field components of the dataset. |
FieldValues | public | Provides access to the values for all fields in the active record for the dataset. |
Filter | public | Specifies the text of the current filter for a dataset. |
Filtered | public | Specifies whether or not filtering is active for a dataset. |
FilterOptions | public | Specifies whether or not filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records. |
Found | public | Indicates whether or not moving to a different record is successful. |
GetMetadata | published | Specifies whether the SQL dataset fetches metadata information along with the data. |
IndexDefs | public | Contains the definitions of all indexes defined on the server for the dataset. |
InternalCalcFields | protected | Indicates whether the dataset includes internally calculated fields. |
InternalConnection | protected | Indicates the component that connects the dataset to its database server, taking into account whether the connection was cloned. |
IOBufferSize | protected | |
IsUniDirectional | public | Indicates whether the dataset is unidirectional. |
MaxBlobSize | protected | Indicates the maximum number of bytes fetched for any BLOB field in the dataset. |
Modified | public | Indicates whether the active record is modified. |
Name | published | Specifies the name of the component as referenced in code. |
NativeCommand | protected | Represents the SQL command that is sent to the server. |
NestedDataSetClass | protected | Indicates the class type to use when creating nested datasets. |
NestedDataSets | protected | Lists all nested datasets. |
NumericMapping | published | Maps fldBCD to either ftFMTBCD or ftBCD field types. |
ObjectView | published | Specifies whether fields are stored hierarchically or flattened out in the Fields property. |
Observers | public | Indicates the TObservers object added to the TComponent. |
OnCalcFields | published | Occurs when an application recalculates calculated fields. |
Owner | public | Indicates the component that is responsible for streaming and freeing this component. |
ParamCheck | protected | Specifies whether the parameter list for an SQL dataset is regenerated when the SQL command changes. |
ParamCount | protected | Indicates the number of parameters listed by the Params property. |
Params | published | Represents the parameters for a query or stored procedure. |
Prepared | public | Specifies whether the command is prepared before execution. |
ProcParams | protected | ProcParams lists the parameter descriptors obtained from the server for any stored procedure parameters. |
RecNo | public | Indicates the active record number in the dataset. |
RecordCount | public | Indicates the total number of records associated with the dataset. |
RecordSize | public | Indicates the size of a record in the dataset. |
RowsAffected | protected | Indicates the number of rows operated on by the latest query execution. |
SchemaInfo | protected | Identifies the metadata with which to populate the dataset. |
SchemaName | published | Specifies the name of the database schema. |
ServerMethodName | published | Sets method name of remote DataSnap server method. |
SortFieldNames | protected | Indicates the sort order when CommandType is ctTable. |
SparseArrays | public | Determines whether a unique TField object is created for each element of an array field. |
SQLConnection | published | Specifies the SQL connection component that connects the dataset to a database server. |
State | public | Indicates the current operating mode of the dataset. |
Tag | published | Stores a NativeInt integral value as a part of a component. |
VCLComObject | public | Represents information used internally by components that support COM. |