Can anyone please explain this sample program in Do While ac
Can anyone please explain this sample program in Do While action MAIN Step %Select(EMPLID) SELECT EM PUD FROM ABC I 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 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
