Example: Manipulation call to the Rules Engine

Previous Next

Here is an example of a PowerShell script which uses the $USEngine object to perform a manipulation.

The return value is the number of records affected by the manipulation.

INVOKE USPowershell.ExecuteScript

WITH

SELECT 'Write-Output $USEngine.ExecuteSQLManipulation("update t_table set table_short = ''TEV'' where table_name = ''T_EVENT'' ") '

This results in:

1

 

See also

Example: Simple script execution

Example: Script execution with parameters

Example: Stateful test

Example: Dynamically Adding C#

Example: Converting Word to PDF

Example: Query call to the Rules Engine

Example: Call to the Rules Engine with variables

Example: Query call to the Rules Engine and loop through result

USPowerShell