简单应用题答案:
1、“数据输出”菜单项的过程代码为:
open data stu
select * from student
close all
“退出”菜单项的命令代码为:set sysmenu to default
2、sele student2.*,成绩 from student2,sc,course2 where 课程名="计算机软件基础" and course2.课程号=sc.课程号 and ;
sc.学号=student2.学号 and 成绩<=85 order by student2.学号 into table noex
综合应用题答案:
“查询”菜单项的过程代码为:
SELECT 姓名,年龄,处方号,药名,生产厂 FROM yisheng,yao,chufang WHERE CHUFANG.药编号=YAO.药编号 AND ;
CHUFANG.职工号=YISHENG.职工号 AND "感冒"$药名 ORDER BY 处方号 INTO TABLE JG9
SELECT * FROM JG9 GROUP BY 姓名 INTO CURSOR aaa
COUNT TO J
INSERT INTO JG9 (处方号) VALUES (J)
“退出”菜单项的命令代码为:set sysmenu to default