Explain for each step in this sample Program MAIN Setp 1 Do
Explain for each step in this sample Program? MAIN Setp 1 Do when % Select(EMPLID) SELECT EMPLID FROM ABC PeopleCode SQLExec \" SELECT COUNT(*) FROM ABC\", &cOUNT;); mESSAGEbOX (0, \", \"0, 0 \" No of Rows in ABC\", & Count); Message Box(0, \" \", 0, 0, \" No of Rows in ABCT Table:\'|&Count;); MessageBox(0, \"\", 0, 0\" Employee ID in State Record: |CNU_AET EMPLID, Value); SQL DELETE FROM ABC Step 2 Do When Select(EMPLID) SELECT EMPLID FROM ABC PeopleCode % Select(EMPLID) SELECT EMPLID FROM ABC PeopleCode SQLExec \" SELECT COUNT(*) FROM ABC\", &cOUNT;); mESSAGEbOX (0, \", \"0, 0 \" No of Rows in ABC\", & Count); Message Box(0, \" \", 0, 0, \" No of Rows in ABCT Table:\'|&Count;); MessageBox(0, \"\", 0, 0\" Employee ID in State Record: |CNU_AET EMPLID, Value); SQL DELETE FROM ABC Step 2 Do When Select(EMPLID) SELECT EMPLID FROM ABC PeopleCode
Solution
Q9
No of Rows in ABC Table: 10
Employee ID in State Record: AA
