Q9. Please explain for each step in this sample Program? MAIN Step1 DoWhen %Sele

Question

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

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

Explanation / Answer

Q9 Answer

No of Rows in ABC Table: 10

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.