Update a single record.

If zero records or more than one record is updated then this method will return False.

Syntax

ISUpdateQueryBuilder.ExecuteUpdateSingle([getCompareDataTable], [compareDataTable], [timeoutSeconds])

Parameters

NameTypeOptionalByRefDescription
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