Provides a Flowgear Trigger that enables monitoring of a change in an MS SQL database.
18.104.22.168 Initial Release
22.214.171.124 Minor Updates and bugfixes
126.96.36.199 Added support for custom connection string fragments
Type: Connection Input
The name or IP address of the MS SQL instance (including the instance name). When using a DropPoint, the Server is relative to the DropPoint. For example, if the DropPoint is installed on the SQL server, the Server property may be simply
Provides the name of the MS SQL Database.
Provides the name of the user account against which the SQL query will be executed. When using a DropPoint, consider used Windows Authentication (
UseWinAuth property) and running the DropPoint under an appropriate Windows account.
Provides a password for the specified user account.
When the Node executes at a DropPoint, allows the user context to be derived from the Windows service account under which the DropPoint is running.
RowsChanged - Specifies that the Node should fire whenever a change occurs in the result set.
RowsReturned - Specifies that the Node should fire whenever execution of WatchQuery results in rows being returned.
Indicates whether the Node should return when rows are returned in the result set or only when the result-set changes.
Provides the interval, in seconds, at which the database should be polled.
Provide a list of extra connection string fragments that are not part of the standard connection properties. The fragments must be in the format
key=value and different fragments should be listed underneath each other.
Type: Multiline Text Input
Provides the query that will be evaluated based on the configuration specified in Connection.
SQL Watcher provides a lightweight mechanism for responding to changes in a database by polling it at the interval specified in the Connection.
FireOn is set to
RowsChanged, the Node will fire its output each time a row with a changed value is returned by the query specified in
FireOn is set to
RowsReturned, the Node will fire its output when at least 1 row is returned by the query specified in