Explain for each step in this sample Program for DoWhen Acti
Explain for each step in this sample Program for DoWhen Action? MAIN step1 DoWhile %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.EMPLTD.Value); SQL DELETE FROM ABC WHERE EMPLID IN (SELECT TOP 5 EMPLID FROM ABC ORDER BY EMPLID DESC)
Solution
No of Rows in ABC Table: 10
Employee ID in State Record: AA
No of Rows in ABC Table: 5
Employee ID in State Record: AA
