SQLInserterExecute Method (String, Int32, Boolean, ExecuteOptions)

Execute the SQL INSERT statement. Note that embedded functions are always resolved unless an executeOptions parameter is provided (without ResolveEmbedded set). Requires that the object was created with the SQLInserter(IDatabase, String) constructor.

Namespace: NetQuarry
Assembly: EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)

Syntax

Copy

public int Execute(
	string logSource = null,
	int commandTimeout = 30,
	bool noRowLockHints = false,
	ExecuteOptions executeOptions = ExecuteOptions.ResolveEmbedded
)

Public Function Execute ( 
	Optional logSource As String = Nothing,
	Optional commandTimeout As Integer = 30,
	Optional noRowLockHints As Boolean = false,
	Optional executeOptions As ExecuteOptions = ExecuteOptions.ResolveEmbedded
) As Integer

Parameters

logSource (Optional): Type: SystemString
The source of the operation, to be logged to the devlog.
commandTimeout (Optional): Type: SystemInt32
Override the default command timeout.
noRowLockHints (Optional): Type: SystemBoolean
If true, no ROWLOCK hints will be added to the statement.
executeOptions (Optional): Type: NetQuarryExecuteOptions
Options to send to Execute(String, ExecuteOptions, String, String, String, Int32, Int32).

Return Value

Type: Int32
The IDENTITY value for the newly inserted record if one exists. Note that you must include the ReturnsIdentity execute option.

Reference

SQLInserter Class

Execute Overload

NetQuarry Namespace

SQLInserterAddLanguageSpecificTextSet("LST470D7920_0?cpp=::|nu=.");Execute Method (String, Int32, Boolean, ExecuteOptions)

Parameters

Return Value

Reference

SQLInserterExecute Method (String, Int32, Boolean, ExecuteOptions)