读程序写出运算结果!请写出下述程序的输出结果.SET TALK OFFSELECT BUSE chargeINDEX ON tno TO chargeSELECT AUSE userSET RELATION TO tno INTO chargeSCANSELECT chargeAVERAGE money TO mm REST WHILE tno=user->tnoSELECT usertno+SPACE(2)+u

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/06 06:23:03

读程序写出运算结果!
请写出下述程序的输出结果.
SET TALK OFF
SELECT B
USE charge
INDEX ON tno TO charge
SELECT A
USE user
SET RELATION TO tno INTO charge
SCAN
SELECT charge
AVERAGE money TO mm REST WHILE tno=user->tno
SELECT user
tno+SPACE(2)+unmae+SPACE(2)+STR(mm,3)
ENDSCAN
4.123 u1 75
456 u2 110
789 u3 300
我算出来的结果不是这个.

先在B工作区打开表charge,且为其按Tno字段建立索引.然后在工作区A打开表user,再与charge表按tno建立关联.在基于表的循环中,按表use中的tno关键字计算表charge中money的平均值.最后输出的结果就是答案.