DataAccessExecuteScalar Method (String, Hashtable, Object)

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored

Namespace: WorkflowGen.My.Data
Assembly: WorkflowGen.My (in WorkflowGen.My.dll) Version: 8.0.5.0 (8.0.5.20210818)

Syntax

public Object ExecuteScalar(
	string sqlQuery,
	Hashtable parameters,
	Object defaultValue
)

Public Function ExecuteScalar ( 
	sqlQuery As String,
	parameters As Hashtable,
	defaultValue As Object
) As Object

sqlQuery: Type: SystemString
A SQL statement to execute
parameters: Type: System.CollectionsHashtable
A parameters collection
defaultValue: Type: SystemObject
A default value returned if the result is null

Type: Object
The first column of the first row in the result set, or a null reference if the result set is empty

DataAccessAddLanguageSpecificTextSet("LST8A44E120_0?cpp=::|nu=.");ExecuteScalar Method (String, Hashtable, Object)