ODAC (V9.5.15) study notes (iv) Toradataset

when critical fields are not automatically generated for complex SQL

Name	Type	Description
Sequencemode	Tsequencemode	ODAC can directly use the sequence objects in Oracle to assign values to the table's primary key, thereby enabling the automatic growth of the primary key. This attribute determines the circumstances under which the sequence is used: Sminsert when new records are added Smpost when the record is updated Note: Fields updated according to the sequence are determined by keyfields
Keysequence		The sequence name used in Oracle to generate the primary key
Checkmode	Tcheckmode	The mode in which the current record is checked before updating a record, including: Cmexception triggers an exception if it finds that the current record has changed in the database Cmnone not checked, default value Cmrefresh changes to refresh the current record
cursor	toracursor	This cursor can be manipulated by assigning a data set to the cursor property of another dataset through the cursors returned by the parameter, such as:  orasql1.parambyname (' Cur '). Ascursor; oraquery1.open;
Lockmode	Tlockmode	The mode at which lock mode is called, with the following values: lmlockdelayed when the user edits is complete and the post is locked and then released Lmlockimmediate when a user starts to enter an edit state and locks until the post or cancel record is released Lmnone Do not lock
Dmlrefresh		Refresh records after insert or update for returning clauses in Oracle8
Encryption	Toraencryption	Specifying a toraencryption component to decrypt data in a dataset
Isplsql	Boolean	To check whether SQL is a PL block
nonblocking		is non-blocking mode, the default is False, and if true, another thread is started to execute SQL, including data updates, insertions, deletions, and data queries
session	point to a Torasession object
smartfetch	tsmartfetchoptions	enabled        whether to allow quick access liveblock      whether minimum memory processing is used, minimum memory is consumed, but performance degrades prefetchedfields        gets additional information for the specified field, This information is useful for improving local filtering, sorting, and so on sqlgetkeyvalues        specify these fields
SqlType		Returns the type code for Oracle processing SQL
Createproccall		To automatically build a call statement for a stored procedure in SQL properties
Erroroffset		Returns the SQL Parse failed error number
Geterrorpos		Returns the row and column where SQL parsing failed
GetArray		Returns a Toraarray object for a field
GetFile		Returns a Torafile object for a field
Getinterval		Returns a Torainterval object for a field
Getkeylist		Returns a list of the primary key fields for the specified database table
Getlob		Returns a Toralob object for a field
GetObject		Returns a Toraobject object for a field
GetRef		Returns a Toraref object for a field
GetTable		Returns a Toranesttable object for a field
Gettimestamp		Returns a Toratimestamp object based on a field
Changenotification		Point to a torachangenotification control that keeps track of the database getting better messages

ODAC (V9.5.15) study notes (iv) Toradataset