SQL Monitor

Previous Top Next

The SQL Monitor executes a SQL statement on a database and compares the resulting dataset to a prior dataset that was returned from the previous time it was run. The component will then return the data and indicate on flag if the record is new, changed, unchanged or deleted.

Populate Dataset	The name of the dataset that will be populated with the affected records and the filter to indicate if the record was changed or not.
Use Connection	The database connection to use with your SQL statement.
SQL Statement	The SQL statement to execute on the database. The statement can be a standard SQL statement or a Stored Procedure as long as a dataset is returned.
Primary Key	In this section you must specify the primary key for the dataset. A primary is required and used to located new, changed or deleted records.
Monitor Fields	If you only want to get notified when certain fields are updated, this field is where you select the fields that you want to monitor for changes.
New	Indicate if you want New records.
Changed	Indicate if you want Changed records.
Unchanged	Indicate if you want Unchanged records.
Deleted	Indicate if you want Deleted records.
Take Data Snapshot	Use this to take a current snapshot of the dataset that will be compared in the next run of the component.