Update zero or more records.

Syntax

ISUpdateQueryBuilder.ExecuteUpdate([recordsAffected], [getCompareDataTable], [compareDataTable], [timeoutSeconds])

Parameters

NameTypeOptionalByRefDescription
recordsAffected Integer Optional ByRef The number of Records that were Affected by the Update. If omitted, a value of -1 is assumed.
getCompareDataTable Boolean Optional Indicates whether a DataTable containing the original and new field values should be retrieved prior to updating. This is useful for auditing changes but incurs a performance penalty since information has to be read from the database prior to being updated. If omitted, a value of False is assumed.
compareDataTable DataTable Optional ByRef The DataTable containing the records prior to updating. If omitted, a value of Nothing is assumed.
timeoutSeconds Integer Optional The number of seconds after which a database connection timeout will occur or -1 to use the default timeout. If omitted, a value of -1 is assumed.

Return Value

Boolean

A Boolean value indicating success.

Member of:
ISUpdateQueryBuilder
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0