Dynamic-SQL Mode
When a row is edited, it can contain some modified values and some values that remain unchanged. For instance, assuming the address of employee Williams is modified, the following example shows the SQL statement that would be generated if dynamic-SQL is enabled:
UPDATE EMP
SET ADDRESS = ‘16, Chocolate Street’
WHERE ID = 7
Here is the SQL statement if dynamic-SQL is disabled:
UPDATE EMP
SET ID = 7,
NAME = ‘Williams’,
ADDRESS = ‘16, Chocolate Street’
WHERE ID = 7
In the latter case, the values for all the columns are sent back to the database each time an update takes place.
Published date: 05/24/2022
Last modified date: 02/24/2022
