ExecuteIntegerQuery Method (sql, record)

Microsoft Deployment Compression & Installer

Copy image CopyHover image
Deployment Tools Foundation ExecuteIntegerQuery Method (sql, record)
Deployment Tools Foundation NamespacesMicrosoft.Deployment.WindowsInstallerDatabaseExecuteIntegerQuery(String, Record)
Executes the specified SQL SELECT query and returns all results as integers.
Declaration Syntax
C# 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
sql (String)
SQL SELECT query string
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.

Win32 MSI APIs: MsiDatabaseOpenView, MsiViewExecute, MsiViewFetch

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.9.1006.0)