IBDAC

TCustomIBCTable Properties

Properties of the TCustomIBCTable class.

For a complete list of the TCustomIBCTable class members, see the TCustomIBCTable Members topic.

Public

Name Description

AutoCommit (inherited from TCustomIBCDataSet)

Used to automatically commit each update, insert or delete statement by database server.

BaseSQL (inherited from TCustomDADataSet)

Used to return SQL text without any changes performed by AddWhere, SetOrderBy, and FilterSQL.

CachedUpdates (inherited from TMemDataSet)

Used to enable or disable the use of cached updates for a dataset.

Conditions (inherited from TCustomDADataSet)

Used to add WHERE conditions to a query

Connection (inherited from TCustomIBCDataSet)

Used to specify the connection in which the dataset will be executed.

Cursor (inherited from TCustomIBCDataSet)

Used for positioned UPDATE and DELETE statements made for the data retrieved with the SELECT statements with the FOR UPDATE clause.

DataTypeMap (inherited from TCustomDADataSet)

Used to set data type mapping rules

Debug (inherited from TCustomDADataSet)

Used to display the statement that is being executed and the values and types of its parameters.

DetailFields (inherited from TCustomDADataSet)

Used to specify the fields that correspond to the foreign key fields from MasterFields when building master/detail relationship.

Disconnected (inherited from TCustomDADataSet)

Used to keep dataset opened after connection is closed.

DMLRefresh (inherited from TCustomIBCDataSet)

Used to refresh record by the RETURNING clause when insert is performed.

Encryption (inherited from TCustomIBCDataSet)

Used to specify encryption options in a dataset.

Exists

Indicates whether a table with the name passed in TableName exists in the database.

ExplainPlan (inherited from TCustomIBCDataSet)

Used to obtain the query execution plan for Table, Query, and SQL components.

FetchAll (inherited from TCustomIBCDataSet)

Used to retrieve all records in a dataset.

FetchRows (inherited from TCustomDADataSet)

Used to define the number of rows to be transferred across the network at the same time.

FilterSQL (inherited from TCustomDADataSet)

Used to change the WHERE clause of SELECT statement and reopen a query.

FinalSQL (inherited from TCustomDADataSet)

Used to return SQL text with all changes performed by AddWhere, SetOrderBy, and FilterSQL, and with expanded macros.

GeneratorMode (inherited from TCustomIBCDataSet)

Used to specify which method is used internally to generate a sequenced field.

GeneratorStep (inherited from TCustomIBCDataSet)

Used to set the increment for increasing or decreasing current generator value when using the automatic key field value generation feature.

Handle (inherited from TCustomIBCDataSet)

Used to specify the handle for the SQL statement of TCustomIBCDataSet.

IndexFieldNames (inherited from TMemDataSet)

Used to get or set the list of fields on which the recordset is sorted.

IsQuery (inherited from TCustomIBCDataSet)

Used to check if the SQL statement returns rows.

KeyExclusive (inherited from TMemDataSet)

Specifies the upper and lower boundaries for a range.

KeyFields (inherited from TCustomDADataSet)

Used to build SQL statements for the SQLDelete, SQLInsert, and SQLUpdate properties if they were empty before updating the database.

KeyGenerator (inherited from TCustomIBCDataSet)

Used to specify the name of a generator that will be used to fill in a key field after a new record is inserted or posted to the database.

LocalConstraints (inherited from TMemDataSet)

Used to avoid setting the Required property of a TField component for NOT NULL fields at the time of opening TMemDataSet.

LocalUpdate (inherited from TMemDataSet)

Used to prevent implicit update of rows on database server.

LockMode (inherited from TCustomIBCDataSet)

Used to indicate when to perform a locking of editing record.

MacroCount (inherited from TCustomDADataSet)

Used to get the number of macros associated with the Macros property.

Macros (inherited from TCustomDADataSet)

Makes it possible to change SQL queries easily.

MasterFields (inherited from TCustomDADataSet)

Used to specify the names of one or more fields that are used as foreign keys for dataset when establishing detail/master relationship between it and the dataset specified in MasterSource.

MasterSource (inherited from TCustomDADataSet)

Used to specify the data source component which binds current dataset to the master one.

Options (inherited from TCustomIBCDataSet)

Used to specify the behaviour of the TCustomIBCDataSet object.

ParamCheck (inherited from TCustomDADataSet)

Used to specify whether parameters for the Params property are generated automatically after the SQL property was changed.

ParamCount (inherited from TCustomDADataSet)

Used to indicate how many parameters are there in the Params property.

Params (inherited from TCustomDADataSet)

Used to view and set parameter names, values, and data types dynamically.

Plan (inherited from TCustomIBCDataSet)

Used to get or set the PLAN clause of the SELECT statement.

Prepared (inherited from TMemDataSet)

Determines whether a query is prepared for execution or not.

Ranged (inherited from TMemDataSet)

Indicates whether a range is applied to a dataset.

ReadOnly (inherited from TCustomDADataSet)

Used to prevent users from updating, inserting, or deleting data in the dataset.

RefreshOptions (inherited from TCustomDADataSet)

Used to indicate when the editing record is refreshed.

RowsAffected (inherited from TCustomDADataSet)

Used to indicate the number of rows which were inserted, updated, or deleted during the last query operation.

RowsDeleted (inherited from TCustomIBCDataSet)

Used to indicate the number of rows that were deleted during the last query operation.

RowsFetched (inherited from TCustomIBCDataSet)

Used to get the number of the currently fetched rows.

RowsInserted (inherited from TCustomIBCDataSet)

Used to indicate the number of rows that were inserted during the last query operation.

RowsUpdated (inherited from TCustomIBCDataSet)

Used to indicate the number of rows that were updated during the last query operation.

SmartFetch (inherited from TCustomIBCDataSet)

The SmartFetch mode is used for fast navigation through a huge amount of records and to minimize memory consumption.

SQL (inherited from TCustomDADataSet)

Used to provide a SQL statement that a query component executes when its Open method is called.

SQLDelete (inherited from TCustomDADataSet)

Used to specify a SQL statement that will be used when applying a deletion to a record.

SQLInsert (inherited from TCustomDADataSet)

Used to specify the SQL statement that will be used when applying an insertion to a dataset.

SQLLock (inherited from TCustomDADataSet)

Used to specify a SQL statement that will be used to perform a record lock.

SQLRecCount (inherited from TCustomDADataSet)

Used to specify the SQL statement that is used to get the record count when opening a dataset.

SQLRefresh (inherited from TCustomDADataSet)

Used to specify a SQL statement that will be used to refresh current record by calling the TCustomDADataSet.RefreshRecord procedure.

SQLType (inherited from TCustomIBCDataSet)

Used to get the typecode of the SQL statement being processed by the InterBase database server.

SQLUpdate (inherited from TCustomDADataSet)

Used to specify a SQL statement that will be used when applying an update to a dataset.

Transaction (inherited from TCustomIBCDataSet)

Used to determine the transaction under which the query of this dataset executes.

UniDirectional (inherited from TCustomDADataSet)

Used if an application does not need bidirectional access to records in the result set.

UpdateObject (inherited from TCustomIBCDataSet)

Used to specify an update object component which provides SQL statements that perform updates of the read-only datasets.

UpdateRecordTypes (inherited from TMemDataSet)

Used to indicate the update status for the current record when cached updates are enabled.

UpdatesPending (inherited from TMemDataSet)

Used to check the status of the cached updates buffer.

UpdateTransaction (inherited from TCustomIBCDataSet)

Used to get or set the transaction for modifying a dataset.

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback