ExecuteIntegerQuery Method (sql, record)

Microsoft Deployment Tools

previous page next page
Deployment Tools Foundation ExecuteIntegerQuery Method (sql, record)
Deployment Tools Foundation Namespaces ► Microsoft.Deployment.WindowsInstaller ► Database ► ExecuteIntegerQuery(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
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) Version: 3.0.0.0 (3.5.1623.0)

previous page start next page