ExecuteScalar Method (sql, record)

previous page next page

Deployment Tools Foundation ExecuteScalar Method (sql, record)

Executes the specified SQL SELECT query and returns a single result.

Declaration Syntax

Visual Basic

Visual C++

public Object ExecuteScalar(
	string sql,
	Record record
)

Public Function ExecuteScalar ( _
	sql As String, _
	record As Record _
) As Object

public:
Object^ ExecuteScalar(
	String^ sql, 
	Record^ record
)

Parameters

record (Record): Optional Record object containing the values that replace the parameter tokens (?) in the SQL query.

Return Value

First field of the first result

Remarks

Exceptions

Exception	Condition
BadQuerySyntaxException	the SQL syntax is invalid
InstallerException	the View could not be executed or the query returned 0 results
InvalidHandleException	the Database handle is invalid

Assembly: Microsoft.Deployment.WindowsInstaller (Module: Microsoft.Deployment.WindowsInstaller) Version: 3.0.0.0 (3.5.1623.0)

previous page start next page