ODAC (V9.5.15) study notes (iv) Tcustomdadataset (4)

6.Options

The Tcustomdadataset selection is tdadatasetoptions and its members are described in the following table :

	Name	Type	Description
Tdadatasetoptions
	Autoprepare	Boolean	Whether to perform prepare automatically before executing SQL
	Cachecalcfields	Boolean	Buffered computed fields (tfield.calculated) and Lookup fields (Tfield.lookup), which can effectively increase the speed of data set access, but also cause memory usage to increase
	Compressblobmode	Boolean	Whether the stored BLOB field contents are compressed
	Defaultvalues	Boolean	The data set will automatically fill in the field's Defaultexpression property
	Detaildelay	Integer	When the primary dataset records scrolling, the delay time (in milliseconds) obtained or from the table DataSet data, which defaults to 0, indicates immediate refresh
	Fieldsorigin	Boolean	Whether to automatically get Origin property values for individual fields when opening datasets
;" >   "	flatbuffers	boolean
   	localmasterdetail	boolean
	Longstrings	Boolean	If true, when the string field is longer than 255, it is handled according to Tstringfield
	Numberrange	Boolean	Whether to limit the range of values for Tintegerfield or Tfloatfield type fields to maximum and minimum
	Queryreccount	Boolean	If the Fetchall property of the DataSet is False, the dataset executes the SQL statement in Sqlreccount to get the number of datasets and fills in the RecordCount attribute
	Quotenames	Boolean	List all related fields in an automatically generated SQL statement
	Removeonrefresh	Boolean	When you call Refreshrecord to refresh data, records that do not already exist in the database are automatically deleted. These records may have been deleted by other users.
	Requiredfields	Boolean	If true, the dataset is automatically set to the Not Null Field object in the database when it is turned on required property is true
	Returnparams	Boolean	True to get the most recent value in the database with the out parameter in the Sqlinsert or Sqlupdate statement after the data record is inserted or updated
	Setfieldsreadonly	Boolean	True to automatically set the ReadOnly property of the non-Update table or data field in the DataSet to True
	Strictupdate	Boolean	When the data set update, delete, and new value operations return from the database the number of records that have occurred does not trigger an exception for 1 o'clock, the number of records returned by the Refreshrecord function is greater than 1 o'clock and will also trigger an exception
	Trimfixedchar	Boolean	Whether to automatically remove spaces from string fields
	Updateallfields	Boolean	Whether to list all fields when an INSERT or UPDATE statement is automatically generated
	UpdateBatchSize	Integer	The number of bulk commit processing allowed to change data when the dataset is in buffered mode, default is 1
Toradatasetoptionsds
	AutoClose	Boolean	Automatically closes the OCI cursor when all data has been obtained.
	Cachelobs	Boolean	Whether to buffer locally to save BLOB data
	Deferredlobread	Boolean	If true, the Blob field under Oracle8 is read only when needed
	Hiderowid	Boolean	Whether to hide the rowID field, by default true
	Keepprepared	Boolean	Whether to continue to be prepared after the dataset is closed
	Scrollablecursor	Boolean	If true, ODAC no longer establishes a local dataset cursor for the data, but instead uses the server's cursor, which is the one that allows two-way scrolling
Toradatasetoptions
	Extendedfieldsinfo	Boolean	Whether the dataset gets extended information for the field when it is turned on, the default is true for the Tsmartquery component, and the other dataset component is False
	Fullrefresh	Boolean	Whether to refresh all fields when the Refreshrecord function is executed, false to refresh only the update fields
	Fieldsasstring	Boolean	Whether fields of data types other than BLOB fields are treated as String fields
	Prefetchrows	Integer	Gets the number of records from the OCI interface when the data is pre-read by the execution SQL
	Prepareupdatesql	Boolean	Whether SQL statements that update data are automatically prepared before they are executed
	Rawasstring	Boolean	Whether to treat fields of raw data types as String type fields, by default True
	Reflectchangenotify	Boolean	If true, and the Changenotification property of the dataset is specified with a component, the table corresponding to the dataset has a DML or DDL change in the database, a change notification message is generated, and the current dataset is refreshed accordingly.
	Statementcache	Boolean	Whether the OCI is allowed to perform the statement buffering of the execution SQL for that dataset. You must ensure that the options.statementcache of the Torasession component is turned on before enabling this feature.

ODAC (V9.5.15) study notes (iv) Tcustomdadataset (4)