Explain for each step in this sample Program MAIN Step 1 Do

$$$

Explain for each step in this sample Program? MAIN Step 1 DoWhen %Select (EMPLID) SELECT EMPLID FROM ABC PeopleCode SOLExec (\"SELECT COUNT(*) FROM ABC\", & Count); MessageBox (0, \"\", 0, 0, \"No of Rows in ABC Table: \" | & Count); MessageBox (0, \"\", 0, 0, \"Employee ID in State Record: \" | CNU, AET, EMPLID, Value); SQL DELETE FROM ABC Step 2 DoWhen %Select(EMPLID) SELECT EMPLID FROM ABC PeopleCode SOLExec (\"SELECT COUNT(*) FROM ABC\", & Count); MessageBox (0, \"\", 0, 0, \"No of Rows in ABC Table: \" | & Count); MessageBox (0, \"\", 0, 0, \"Employee ID in State Record: \"| CNU, AET, EMPLID, Value); SQL DELETE FROM ABC

Solution

Assume a Table ABC is having EMPLID field and there are 10 Employee IDs starting from AA, BB, CC, to JJ.
• Application Engine first executes the Select Statement in DoWhen Action.
• Condition gets satisfies as there are 10 rows.(At least one row needed)
• In PeopleCode, message will be displayed as
No of Rows in ABC Table: 10
Employee ID in State Record: AA
• In SQL Action, All the 10 rows will be deleted from table.
• As DoWhen is not a looping Action it will not go back to the Select Statement and execute. It comes out from the Step and executes the next Step.
• In Step2, DoWhen will be executed first.
• Condition gets fail as there are no rows. So it will not execute the Subsequent Actions PeopleCode and SQL.