Represents a Builder utility to create Update or Insert Into Queries.

Methods

Name Description
AppendFieldString Instruct the Query Builder to create an update to Append text to a String field.
Clear Clears this object.
ExecuteAddNew Add a new record.
ExecuteInsertInto System Use Only Obsolete Executes an INSERT INTO query to add new records from the results of a SELECT query.
ExecuteUpdate Update zero or more records.
ExecuteUpdateSingle Update a single record.
ExecuteUpdateSingleWithRetry System Use Only
HasFields Returns True if there are any fields being updated.
IncrementDecrementField Instruct the Query Builder to create an update to Increment or Decrement a numeric field.
SetBinary Set a Boolean field.
SetBoolean Set a Boolean field.
SetDate Set a Date field.
SetDateTime Set a Date field that includes Time information..
SetDateTimePrecise Set a Date field that includes Time information - fractions of a second will not be removed.
SetDecimal Set a Decimal (currency) field.
SetDouble Set a Double field.
SetField Set a Field to another field or expression.
SetIdentity Set an non-updatable Identity field.
SetInteger Set an Integer field.
SetIntegerBoolean Set a Boolean value on an Integer field.
SetIntegerForeignKey Set an Integer Foreign Key field.
SetIntegerTimeZoneId Set an Integer field from a String Time Zone Id.
SetLong Set an Long field.
SetNull Set a field to Null.
SetNullBinary Set a binary field to Null.
SetShort Set a Short Integer field.
SetString Set a String field.

Properties

Name Description
AllowReadOnlyUpdates Indicates whether records can be added, deleted or updated if the database is currently in read-only mode.
Joins Read-Only A collection of table joins to include in the SQL UPDATE Query.
SqlWhere Read-Only The SQL Where builder.
Table The name of the database Table to update.
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0