4. master-Slave table relationship
Name |
Type |
Description |
Mastersource |
|
The DataSource component that corresponds to the primary table from the table |
Detailfields |
|
Foreign key fields corresponding to the main table field from the tables |
Masterfields |
|
A field in the primary table that is associated from a table, typically a key field for the primary table |
5. Implement the relevant
Name |
Type |
Description |
Keyfields |
String |
The key fields used to build SQL in Datasets Sqldelete, Sqlinsert, and Sqlupdate properties. This property is also used in cases where the primary key value is automatically obtained through the sequence |
rowsaffected |
Integer |
The number of records affected by the execution of inserting, updating, and deleting SQL |
ReadOnly |
Boolean |
is read-only |
Breakexec |
|
Interrupts SQL execution on the server, which is a very useful feature in nonblocking mode |
Execute |
|
Execute SQL statement |
Executing |
Boolean |
Determine if the SQL statement is in execution |
AfterExecute |
|
Events triggered after executing an SQL statement |
Afterupdateexecute |
|
Events that are triggered after inserting, modifying, deleting, and querying SQL statements |
Beforeupdateexecute |
|
Perform events that are triggered before inserting, modifying, or deleting SQL statements |
ODAC (V9.5.15) study notes (iv) Tcustomdadataset (3)