Name |
Type |
Description |
DataSet |
|
Point to the dataset that needs to perform the update operation |
DeleteObject |
|
When a delete operation is performed, another dataset is executed by this property, which performs more delete actions |
Deletesql |
TStrings |
Delete the required SQL statement |
InsertObject |
|
When an insert operation is performed, another dataset is executed through this property, which performs more insert actions |
Insertsql |
|
Insert the SQL statement you want |
LockObject |
|
When a record lock operation is performed, another dataset is executed by this property, which performs more of the action |
Locksql |
|
SQL statement required to record the lock |
Modifyobject |
|
When an update operation is performed, another dataset is executed through this property, which performs more update actions |
Modifysql |
|
Update the required SQL statements |
Refreshobject |
|
When a refresh operation is performed, another dataset is executed through this property, which performs more refresh actions |
Refreshsql |
|
Refresh the required SQL statements |
Sql |
|
Returns the corresponding SQL statement based on the specified action type |
Apply |
|
Set parameters and execute SQL for data updates. If the parameter is included, its execution efficiency is higher than execsql |
Execsql |
|
Set parameters and execute SQL for data updates. If parameters are included, apply executes more efficiently. |
ODAC (V9.5.15) study notes (vii) TORAUPDATESQL