Can anyone please explain this sample program in Do While ac
Can anyone please explain this sample program in Do While action MAIN Step 1 DoWhile %Select (Emplid) SELECT EMPLID FROM ABC PeopleCode SQLExec(\"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 DELETED FROM ABC WHERE EMPLID IN (SELECT TOP 5 EMPLID FROM ABC ORDER BY EYPLID 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
