Number Of Columns In Updates Property

Previous Next

This is where you specify what the UPDATE statements generated by USoft Developer will look like. For tables with column counts lower then this value the conceptual processor will generate UPDATE statements that update all columns of the table. This has the advantage that RDBMS cursors created for these statements can be re-used. This increases performance.

If the column count of a table is equal to or higher than this value, UPDATE statements on this table will only update the columns actually updated.

The default value is 10.

NOTE:

The Number of Columns In Updates property is an application-level property.