ExecuteIntegerQuery Method (sql, record)

Deployment Tools Foundation ExecuteIntegerQuery Method (sql, record)

Executes the specified SQL SELECT query and returns all results as integers.

Declaration Syntax

Visual Basic

Visual C++

public IList<int> ExecuteIntegerQuery(
	string sql,
	Record record
)

Public Function ExecuteIntegerQuery ( _
	sql As String, _
	record As Record _
) As IList(Of Integer)

public:
IList<int>^ ExecuteIntegerQuery(
	String^ sql, 
	Record^ record
)

Parameters

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

Return Value

All results combined into an array

Remarks

Multiple rows columns will be collapsed into a single one-dimensional list.

Exceptions

Exception	Condition
BadQuerySyntaxException	the SQL syntax is invalid
InstallerException	the View could not be executed
InvalidHandleException	the Database handle is invalid

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