第四章习题答案 9. replace姓名 with m.姓名 13题 1) list for recno(=5或 go 5 displa 2)list all for recno (>=5 and recno (<=10 p 5 list next 6 3) list fields姓名,出生年月for出生年月>{^1980/01/01 4)1 ist for出生年月>={1983/12/31}and出生年月<={1985/01/01} go top insert before 6)browse for recno (=reccount o 7) replace入学成绩with入学成绩+20 for year(date0)-year(出生年月)<16and少数民族否 8)copy to xsda use xsda delete all for mod (recno(, 2)=0 9) index on-入学成绩 tag c] list next 5 10) count all for year(出生年月)=1985 to number 11) average year( date()-year(出生年月)for性别="女 average year( date()-year(出生年月)for性别="男 12) locate for少数民族否 display 3) index on学号 tag xh desc index on出生年月 tag cs 14) calculate max(出生年月)tox1 calculate min(出生年月)tox2 15) index on性别 tag xb total on性别 to hz fields入学成绩 4.一对一的关联: use student score index on学号tag sele 1 set rela to学号 into b brow sele 2第四章习题答案 9. replace 姓名 with m.姓名 10. 5 13 题 1) list for recno()=5 或 go 5 display 2) list all for recno()>=5 and recno()<=10 或 go 5 list next 6 3) list fields 姓名,出生年月 for 出生年月>={^1980/01/01} 4) list for 出生年月>={^1983/12/31} and 出生年月<={^1985/01/01} 5) go top insert before 6) browse for recno()=reccount() 7) replace 入学成绩 with 入学成绩+20 for year(date())-year(出生年月)<16 and 少数民族否 8) copy to xsda use xsda delete all for mod(recno(),2)=0 pack 9) index on -入学成绩 tag cj list next 5 10) count all for year(出生年月)=1985 to number 11) average year(date())-year(出生年月) for 性别="女" average year(date())-year(出生年月) for 性别="男" 12) locate for 少数民族否 display 13) index on 学号 tag xh desc index on 出生年月 tag cs 14) calculate max(出生年月) to x1 calculate min(出生年月) to x2 15) index on 性别 tag xb total on 性别 to hz fields 入学成绩 14．一对一的关联： use student sele 2 use score index on 学号 tag xh sele 1 set rela to 学号 into b brow sele 2 brow