ExecuteScalar Method (sql, record)

DTF API

previous page next page
Copy image CopyHover image
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.
Declaration Syntax
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
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
Object
First field of the first result
Remarks

Win32 MSI APIs: MsiDatabaseOpenView, MsiViewExecute, MsiViewFetch

Exceptions
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)

previous page start next page