Q10 Please explain for each step in this sample Program MAIN

Q10. Please explain for each step in this sample Program?

MAIN

Step1

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

DELETE FROM ABC WHERE EMPLID IN ( SELECT TOP 5 EMPLID FROM ABC ORDER BY EMPLID DESC)

Solution

Q10

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