Question

VFP程序设计命令如何替换

2、将xckm1、xckm2字段的数字替换成相应的等级：（6为A+,5为A,4为B+,3为B,2为C,1为D）;
3、为奖励高分高等级考生，请分别查询出文科和理科的等级为A以上的前10名考生。
4、请统计各专业的总分（tzf）的平均分。
5、为方便邮寄，请分类汇总出相同邮寄地址的同学人数，并分别附相同地址同学的名单

Answer 1

因为xckm1、xckm2字段的数据类型一定以为数值型，而A+、A、B等为字符型，所以必须增加两个字符型的字段才行。分别设为：xckmdj1、xckmdj2。用下述命令替换：
repl xckmdj1 with “A+" for xckm1=6
repl xckmdj1 with “A" for xckm1=5
repl xckmdj1 with “B+" for xckm1=4
repl xckmdj1 with “B" for xckm1=3
repl xckmdj1 with “C" for xckm1=2
repl xckmdj1 with “D" for xckm1=1
repl xckmdj2 with “A+" for xckm2=6
repl xckmdj2 with “A" for xckm2=5
repl xckmdj2 with “B+" for xckm2=4
repl xckmdj2 with “B" for xckm2=3
repl xckmdj2 with “C" for xckm2=2
repl xckmdj2 with “D" for xckm2=1