SDAC

TMSDataSetOptions Properties

Properties of the TMSDataSetOptions class.

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

Public

Name Description

AllFieldsEditable

Not supported.

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.

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).

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.

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

AutoPrepare

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

AutoRefresh

Used to enable automatic refresh of a dataset every AutoRefreshInterval seconds.

AutoRefreshInterval

Used to define in what time interval in seconds the Refresh or TCustomMSDataSet.RefreshQuick method of DataSet is called.

CheckRowVersion

Used to determine whether dataset checks for rows modifications made by another user on automatic generation of SQL statement for update or delete data.

CursorUpdate

Used to specify the way data updates reflect on database when modifying dataset by using server cursors ctKeySet and ctDynamic.

DefaultValues

Used to enable TCustomMSDataSet to fill the DefaultExpression property of TField objects by an appropriate value.

DescribeParams

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

DisableMultipleResults

Used to forbid multiple results usage by a command.

DMLRefresh

Used to refresh a record when insertion or update is performed.

EnableBCD

Used to specify whether to treat numeric fields as floating-point or BCD.

FullRefresh

Used to specify the fields to include in the automatically generated SQL statement when calling the TCustomDADataSet.RefreshRecord method.

HideSystemUniqueFields

Used to hide system fields for the prSQL, prNativeClient and prMSOLEDB providers. The default value is True.

LastIdentityValueFunction

Determines which system function to use to obtain an identifier when adding a record. The default value is vfScopeIdentity.

LongStrings

Represents string fields with the length that is greater than 255 as TStringField.

NonBlocking

Used to fetch rows in a separate thread.

NumberRange

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

PrepareUpdateSQL

Used to automatically prepare update queries before execution.

QueryIdentity

Used to specify whether to request the Identity field value on execution of the Insert or Append method.

QueryRecCount

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

QuoteNames

Used for TCustomMSDataSet to quote all field names in autogenerated SQL statements.

ReflectChangeNotify

Indicates whether DataSet will be automatically refreshed when the underlying data on the server is changed.

RemoveOnRefresh

Used for dataset to locally remove record on refresh if it does not match filter condition (WHERE clause for refresh SQL) anymore.

RequiredFields

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

ReturnParams

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

SetEmptyStrToNull

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

StrictUpdate

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

TrimFixedChar

Used to specify whether to discard all trailing spaces in the fixed-length string fields of a dataset.

TrimVarChar

Used to specify whether to discard all trailing spaces in the variable-length string fields of a dataset.

UniqueRecords

Used to specify whether to query additional keyfields from the server.

See Also

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