Q10. Please explain for each step in this sample Program? MAIN Step1 DoWhile %Se

Question

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)

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)

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.