Sqlnext

Fetches the next record in a multi-row query initiated with Sqlcursor action.

Dependencies

• Sqlnext does nothing if a query has not been opened with the Sqlcursoraction.
• A Loop action is typically used to repetitively call the Sqlnext. As long as more data exists to fetch, the Default branch condition of the Sqlnext will be triggered. The End Of Dataset branch condition will be triggered when Sqlnext is executed and there are no remaining records.
• If three records from a query were being fetched:
  • Sqlnext would fetch the first row.
  • Two iterations of Sqlnext would retrieve the next two rows.
  • A third iteration would trigger the End Of Dataset branch condition off of the Sqlnext action.

Supported Script Types

Generic	Email	Chat	Phone	Voicemail	Work Item	SMS

Input Properties

These properties define data that the action uses when executing.

Property	Description
Add Caption	Enter a short phrase that uniquely identifies this action in the script. The caption appears on the script canvas under the action icon.
Timeout Sec	The number of seconds the action waits to execute before timing out. The value must be between 0 and 60.

Result Branch Conditions

Result branch conditions allow you to create branches in your script to handle different outcomes when an action executes.

Condition	Description
Default	Path taken unless the script meets a condition that requires it to take one of the other branches. It is also taken if the action's other branches are not defined.
EndOfDataset	Path taken once the last row has been fetched and there is another occurrence of Sqlnext. Once triggered, the dataset will automatically be closed. Always use Sqlclose before the end of the script.