Overview
Creates a connection to the relevant system with the information defined on the domain and runs the query. Returns the number of affected rows
number $Database.ExecuteNonQuery(connectionName: string, query: string, timeout: number, parameters: object)
Arguments
string connectionName
name of external database name
string query
query to be run
number timeout
request timeout. Optional.
object parameters
parameters set on the query. Optional.
Remarks
CONNECTION_NAME can be set on Edit Domain → URL Credentials → External Database Credentials.
Example
$Database.ExecuteNonQuery("CONNECTION_NAME", "update wDomains set Status = 1 where Id=@Id", {
Id: id
});