IBDAC

TIBCDataSetOptions Properties

Properties of the TIBCDataSetOptions class.

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

Public

Name Description

AutoPrepare (inherited from TDADataSetOptions)

Used to execute automatic TCustomDADataSet.Prepare on the query execution.

CacheCalcFields (inherited from TDADataSetOptions)

Used to enable caching of the TField.Calculated and TField.Lookup fields.

CompressBlobMode (inherited from TDADataSetOptions)

Used to store values of the BLOB fields in compressed form.

DetailDelay (inherited from TDADataSetOptions)

Used to get or set a delay in milliseconds before refreshing detail dataset while navigating master dataset.

FieldsOrigin (inherited from TDADataSetOptions)

Used for TCustomDADataSet to fill the Origin property of the TField objects by appropriate value when opening a dataset.

FlatBuffers (inherited from TDADataSetOptions)

Used to control how a dataset treats data of the ftString and ftVarBytes fields.

InsertAllSetFields (inherited from TDADataSetOptions)

Used to include all set dataset fields in the generated INSERT statement

LocalMasterDetail (inherited from TDADataSetOptions)

Used for TCustomDADataSet to use local filtering to establish master/detail relationship for detail dataset and does not refer to the server.

LongStrings (inherited from TDADataSetOptions)

Used to represent string fields with the length that is greater than 255 as TStringField.

MasterFieldsNullable (inherited from TDADataSetOptions)

Allows to use NULL values in the fields by which the relation is built, when generating the query for the Detail tables (when this option is enabled, the performance can get worse).

NumberRange (inherited from TDADataSetOptions)

Used to set the MaxValue and MinValue properties of TIntegerField and TFloatField to appropriate values.

QueryRecCount (inherited from TDADataSetOptions)

Used for TCustomDADataSet to perform additional query to get the record count for this SELECT, so the RecordCount property reflects the actual number of records.

QuoteNames (inherited from TDADataSetOptions)

Used for TCustomDADataSet to quote all database object names in autogenerated SQL statements such as update SQL.

RemoveOnRefresh (inherited from TDADataSetOptions)

Used for a dataset to locally remove a record that can not be found on the server.

RequiredFields (inherited from TDADataSetOptions)

Used for TCustomDADataSet to set the Required property of the TField objects for the NOT NULL fields.

ReturnParams (inherited from TDADataSetOptions)

Used to return the new value of fields to dataset after insert or update.

SetFieldsReadOnly (inherited from TDADataSetOptions)

Used for a dataset to set the ReadOnly property to True for all fields that do not belong to UpdatingTable or can not be updated.

TrimFixedChar (inherited from TDADataSetOptions)

Specifies whether to discard all trailing spaces in the string fields of a dataset.

UpdateAllFields (inherited from TDADataSetOptions)

Used to include all dataset fields in the generated UPDATE and INSERT statements.

UpdateBatchSize (inherited from TDADataSetOptions)

Used to get or set a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.

Published

Name Description

AutoClose

Used to for CustomIBCDataSet to close cursor after fetching all rows.

BooleanDomainFields

Used to create TBooleanField for fields that have domain of the integer data type, and the domain name contains 'BOOLEAN'.

CacheArrays

Used to allocate local memory buffer for a copy of the array.

CacheBlobs

Used to allocate local memory buffer for a copy of the BLOB.

ComplexArrayFields

Used to store array fields as TIBCArrayField objects.

DefaultValues

Used for TCustomIBCDataSet to fill the DefaultExpression property of TField objects by the appropriate value.

DeferredArrayRead

Used for fetching all InterBase array values when they are explicitly requested.

DeferredBlobRead

Used for fetching all InterBase BLOB values when they are explicitly requested.

DescribeParams

Used to specify whether to query TIBCParam properties from the server when executing the TCustomDADataSet.Prepare method.

ExtendedFieldsInfo

Used to perform an additional query to get information about the returned fields and the tables they belong to.

FieldsAsString

Used to treat all non-BLOB fields as being of string datatype.

FullRefresh

Used to refresh fields from all tables of the query.

PrepareUpdateSQL

Used to automatically prepare update queries before execution.

QueryRowsAffected

Used to increase the performance of update operations.

SetDomainNames

Used to retrieve the DOMAIN name for a field.

SetEmptyStrToNull

Force replace of empty strings with NULL values in data. The default value is False.

StreamedBlobs

Used to handle and save BLOBs as streamed BLOBs.

StrictUpdate

Used for TCustomIBCDataSet to raise an exception when the number of the updated or deleted records is not equal 1.

See Also

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