EPUB | CHM | PDF

TPSQLTable.Properties

Top Previous Next

Please see TPSQLTable properties short descriptions below:

Derived from TDataSet

Active

Specifies whether or not a dataset is open.

AutoCalcFields

Determines when the OnCalcFields event is triggered.

Bof

Indicates whether or not a cursor is positioned at the first record in a dataset.

Bookmark

Specifies the current bookmark in the dataset.

DefaultFields

Indicates whether a dataset's underlying field components are generated dynamically when the dataset is opened.

Eof

Indicates whether or not a cursor is positioned at the last record in a dataset.

FieldCount

Indicates the number of field components associated with the dataset.

FieldDefList

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.

Found

Indicates whether or not moving to a different record is successful.

Modified

Indicates whether the active record is modified.

Name

Designates the name of the dataset as referenced by other components.

ObjectView

Specifies whether fields are to be stored hierarchically or flattened out in the Fields property.

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.

In TPSQLDataset

AllowSequenced

Determines that database records can be located by sequence numbers.

AutoRefresh

Specifies whether server-generated field values are refetched automatically.

BlockReadSize

Determines how many record buffers are read in each block.

CacheBlobs

Determines whether BLOB fields are cached in memory.

Database

Specifies the database component for which this dataset represents one or more tables.

Filter

Specifies the text of the current filter for a dataset.

Filtered

Specifies whether filtering is active for a dataset.

FilterOptions

Specifies whether filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records.

KeySize

Specifies the size of the key for the current index of the dataset.

Options

Specifies various behavioral properties of the TPSQLDataset and it's descendants.

RecNo

Indicates the current record in the dataset.

RecordCount

Indicates the total number of records associated with the dataset.

RecordSize

Indicates the size of a record in the dataset.

SortFieldNames

Specifies field names and sorting order to sort opened dataset on the client side.

UpdateMode

Determines how PostgreSQL finds records when updating to an SQL database.

UpdateObject

Specifies the update object component used to update a read-only result set when CachedUpdates property is enabled.

In TPSQLTable

BatchModify

Batch insert, update and delete records.

CanModify

Indicates whether an application can insert, edit, and delete data in a table.

Comment

Holds description assigned to table.

DataSource

Provides read-only access to the data source for the master dataset when this table is the detail of a master/detail relationship.

DefaultIndex

Specifies if the data in the table should be ordered on a default index when opened.

Exists

Indicates whether the underlying database table exists.

FieldDefs

Points to the list of field definitions for the dataset.

Handle

Specifies the cursor handle for the dataset.

HasOIDs

Specifies whether a table has OID system column or not.

IndexDefs

Contains information about the indexes for a table.

IndexFieldCount

Indicates the number of fields that comprise the current key.

IndexFieldNames

Lists the columns to use as an index for a table.

IndexFields

Lists the fields of the current index.

IndexName

Identifies a secondary index for the table.

KeyExclusive

Specifies how the upper and lower boundaries for a range should be interpreted.

KeyFieldCount

Specifies the number of fields to use when conducting a partial key search on a multi-field key.

Limit

Specifies the number of rows need to be fetched from table.

MasterFields

Specifies one or more fields in a master table to link with corresponding fields in this table in order to establish a master-detail relationship between the tables.

MasterSource

Specifies the name of the data source for a dataset to use as a master table in establishing a detail-master relationship between this table and another one.

Offset

Specifies the row number from which data to be fetched from table.

Owner

Contains table owner name.

ReadOnly

Specifies whether a table is read-only for this application.

StoreDefs

Indicates whether the table's field and index definitions persist with the data module or form.

ShowSystemTables

Specifies ability to shoe system tables at design-time.

TableID

Specifies the ID (oid) of the table associated with this table component.

TableName

Indicates the name of the database table that this component encapsulates.

Tablespace

Specifies the table tablespace within the cluster.