The Goto Step (Physician Loop)

End the Successful output branch of the DB Get step by dragging a Goto step from the General palette to the Design pane, and dropping it over the Play Prompt step icon under the Successful icon under the DB Get step icon, as shown in figure database.aef script.

Then configure the Goto step to instruct the script to loop back to the DB Get step and continue to retrieve a row of data from the table each time this step executes.

When the script reads every row of data and no data is found, the script automatically drops down to the DB Get step No Data output branch. (See The No Data Output Branch.)