

Deployment Tools Foundation
ExecuteScalar Method (sql, record)
Deployment Tools Foundation Namespaces ► Microsoft.Deployment.WindowsInstaller ► Database ► ExecuteScalar(String, Record)
Executes the specified SQL SELECT query and returns a single result.

C# | Visual Basic | Visual C++ | F# |
public Object ExecuteScalar( string sql, Record record )
Public Function ExecuteScalar ( sql As String, record As Record ) As Object
public: Object^ ExecuteScalar( String^ sql, Record^ record )
member ExecuteScalar : sql : string * record : Record -> Object

Object
First field of the first result
First field of the first result

Win32 MSI APIs: MsiDatabaseOpenView, MsiViewExecute, MsiViewFetch

Exception | Condition |
---|---|
BadQuerySyntaxException | the SQL syntax is invalid |
InstallerException | the View could not be executed
or the query returned 0 results |
InvalidHandleException | the Database handle is invalid |
Assembly: Microsoft.Deployment.WindowsInstaller (Module: Microsoft.Deployment.WindowsInstaller.dll) Version: 3.0.0.0 (3.11.1.2318)