Deployment Tools Foundation
ExecuteIntegerQuery Method (sqlFormat, args)
Deployment Tools Foundation Namespaces ► Microsoft.Deployment.WindowsInstaller ► Database ► ExecuteIntegerQuery(String, array<Object>[]()[])
Executes the specified SQL SELECT query and returns all results as integers.

C# | Visual Basic | Visual C++ |

All results combined into an array

The sqlFormat parameter is formatted using Format(String, array<Object>[]()[]).
Multiple rows columns will be collapsed into a single one-dimensional list.
Win32 MSI APIs: MsiDatabaseOpenView, MsiViewExecute, MsiViewFetch

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