读程序写出运算结果!请写出下述程序的输出结果.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/11/25 10:17:07
读程序写出运算结果!请写出下述程序的输出结果.SETTALKOFFSELECTBUSEchargeINDEXONtnoTOchargeSELECTAUSEuserSETRELATIONTOtnoINT

读程序写出运算结果!请写出下述程序的输出结果.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
读程序写出运算结果!
请写出下述程序的输出结果.
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
我算出来的结果不是这个.

读程序写出运算结果!请写出下述程序的输出结果.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
先在B工作区打开表charge,且为其按Tno字段建立索引.然后在工作区A打开表user,再与charge表按tno建立关联.在基于表的循环中,按表use中的tno关键字计算表charge中money的平均值.最后输出的结果就是答案.