What does a program in VF mean is as follows

close all Close all in vf.

use four to open a table named four.

copy to bak1 copies table four to table bak1.

use bak1 to open table bak1

do while not eof() loop to start, and the loop condition is not until the end of the file.

KSH = Candidate Number Pay the field value of the candidate number in BAK1 to KSH

Select Score from KSCJB where Candidate Number=KSH and Exam Subject="101" into array arr

Candidate number = KSH and Exam subjects = in the inquiry form KSCJB (Examination Score Sheet)."101"and assign a value to the array arr

REPL Political Achievement with ARR(1).

Replace the political grade field in the BAK1 table with the value of arr(1), as there is no range to replace only the current record. The following sentences are the same, but the subjects are different.

Select Score from KSCJB where Candidate Number=KSH and Exam Subject="102" into array arr

REPL Foreign Language Score with ARR(1).

Select Score from KSCJB where Candidate Number=KSH and Exam Subject="103" into array arr

REPL High Mathematics Score with ARR(1).

Select Score from KSCJB where Candidate Number=KSH and Exam Subject="104" into array arr

REPL Grades with ARR(1).

Move the record in skip bak1 down by one item.

The enddo loop ends.

Repl All overall score with Politics score + foreign language score + high math score + professional course score.

In table BAK1, replace the total score with political score + foreign language score + advanced math score + professional course score Because the range is all, it is the total score of the person who sought the job.

close all Close all.

select * from bak1 where Total Score》=330 into table four order by Total Score desc

Add the record of "Overall Score" = 330 in Table BAK1 to Table Four and arrange them in descending order of overall score.

set safety on Open the safety prompt.

You can take a look at the textbook about the SQL part.,It's all on it.,If you're self-studying, it's actually still difficult.,You can sign up for a class.,I just signed up for the class and took the test.。 I wish you success.