Explain for each step in this sample Program for Do While Ac
Explain for each step in this sample Program for Do While Action? Do while %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 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
