Data Access and SQL > SQL Tables > Run-Time Options > Dynamic-SQL Mode
 
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.

Version 5.7
Copyright © 2013, Rogue Wave Software, Inc. All Rights Reserved.