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
)

member ExecuteIntegerQuery : 
        sql : string * 
        record : Record -> IList<int>

Parameters

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

Return Value

IList<(Of <(<'Int32>)>)>
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.dll) Version: 3.0.0.0 (3.11.1.2318)