CODEWITHSUNDEEP
flowgear
Shawn de Wet
Shawn de Wet

Reputation: 5976

Flowgear SQL Watcher

How do I configure the SQL Watcher trigger in Flowgear? The config options screen does not contain a field where I can enter the actual Query whose results need to be monitored. Here is a screen shot of what I'm seeing.The SQL Watcher config screen

Also, what is the difference between the "Notify" and the "Poll" options in the "WatchMethod" dropdown?

Upvotes: 0

Views: 111

Answers (1)

CamW
CamW

Reputation: 3363

You'll first create the connection then add an instance of the SQL Watcher to a workflow and select the connection you've just created. There is then a field on the SQL Watcher node in which you can specify the SQL query you'd like to execute.

The Poll option in Watch Method will check the database at the specified WatchPollInterval to check for changes. The Notify method will use Sql Query notification instead https://msdn.microsoft.com/en-us/library/t9x04ed2%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396

Upvotes: 0

Related Questions