Please see TPSQLTable properties short descriptions below: Derived from TDataSet Specifies whether or not a dataset is open. Determines when the OnCalcFields event is triggered. Indicates whether or not a cursor is positioned at the first record in a dataset. Specifies the current bookmark in the dataset. Indicates whether a dataset's underlying field components are generated dynamically when the dataset is opened. Indicates whether or not a cursor is positioned at the last record in a dataset. Indicates the number of field components associated with the dataset. Points to the list of field definitions for the dataset. Lists the field components of a dataset. Lists all non-aggregate field components of the dataset. Provides access to the values for all fields in the active record for the dataset. Indicates whether or not moving to a different record is successful. Indicates whether the active record is modified. Designates the name of the dataset as referenced by other components. Specifies whether fields are to be stored hierarchically or flattened out in the Fields property. Determines whether a unique TField object is created for each element of an array field. Indicates the current operating mode of the dataset. In TPSQLDataset Determines that database records can be located by sequence numbers. Specifies whether server-generated field values are refetched automatically. Determines how many record buffers are read in each block. Determines whether BLOB fields are cached in memory. Specifies the database component for which this dataset represents one or more tables. Specifies the text of the current filter for a dataset. Specifies whether filtering is active for a dataset. Specifies whether filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records. Specifies the size of the key for the current index of the dataset. Specifies various behavioral properties of the TPSQLDataset and it's descendants. Indicates the current record in the dataset. Indicates the total number of records associated with the dataset. Indicates the size of a record in the dataset. Specifies field names and sorting order to sort opened dataset on the client side. Determines how PostgreSQL finds records when updating to an SQL database. Specifies the update object component used to update a read-only result set when CachedUpdates property is enabled. In TPSQLTable Batch insert, update and delete records. Indicates whether an application can insert, edit, and delete data in a table. Holds description assigned to table. Provides read-only access to the data source for the master dataset when this table is the detail of a master/detail relationship. Specifies if the data in the table should be ordered on a default index when opened. Indicates whether the underlying database table exists. Points to the list of field definitions for the dataset. Specifies the cursor handle for the dataset. Specifies whether a table has OID system column or not. Contains information about the indexes for a table. Indicates the number of fields that comprise the current key. Lists the columns to use as an index for a table. Lists the fields of the current index. Identifies a secondary index for the table. Specifies how the upper and lower boundaries for a range should be interpreted. Specifies the number of fields to use when conducting a partial key search on a multi-field key. Specifies the number of rows need to be fetched from table. 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. 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. Specifies the row number from which data to be fetched from table. Contains table owner name. Specifies whether a table is read-only for this application. Indicates whether the table's field and index definitions persist with the data module or form. Specifies ability to shoe system tables at design-time. Specifies the ID (oid) of the table associated with this table component. Indicates the name of the database table that this component encapsulates. Specifies the table tablespace within the cluster. |