thanks Can anyone please explain this sample program in Do W
thanks
Can anyone please explain this sample program in Do While action MAIN Step1 %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 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
