Q9 Please explain for each step in this sample Program MAIN

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

MAIN

Step1

DoWhen

%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

Step2

DoWhen

%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

Solution

Q9 Answer

No of Rows in ABC Table: 10

Employee ID in State Record: AA