osta-vfp题库相关命令参考答案.doc

注意：若表已自动打开，则不需要使用use命令打开2.11、 edit fields 编号,姓名,职称,讲课工作量,讲课酬金 for 授课班级=”94公路_2”或者：locate for授课班级=”94公路_2” edit2、 goto 5 display next 6 fields 姓名,系名,授课班级,授课人数,课时 3、 copy structure to c:s1_1a.dbf4、 goto 20 replace rest 讲课工作量 with int(课时*授课人数/20) 5、 append from c:y2_1b.dbf6、 go bottomscatter to memvarappend blankgather from menvar7、 recall for 系名=”经济系”8、 list for delete()9、 sort to s2_1dx.dbf on 职称/A,授课人数/D2.21、goto 2 display rest for GZRQ=1990/12/31或者 display rest for Year(GZRQ)100.00Pack2.31、change for ZY=”学生”2、list fields 姓名,NL,F1,F2,F3 for XL=”大专” or XL=”大学”或者 display all fields 姓名,NL,F1,F2,F3 for XL=”大专” or XL=”大学”3、goto 20 replace rest ZF with sqrt(560) 4、菜单操作，追加记录，数据表已打开： a选择“表”菜单/追加记录（A）b在出现的“追加来源”对话框中做相应设定：类型：delimited text 来源：y2_7b.txtc点击“确定”按钮即可(注：类型和来源要根据题目的要求来定)5、use y2_7d.dbfCopy to c:y2_7c.dbfUse c:y2_7c.dbfRecall for XL=”初中”6、delete for ZY=”干部” and year(NN)recount()-70 or T3=”3” and recno()recount()-704、replace XM with “王一东” for len(XM)=4或者：locate for len(XM)=4 Replace XM with “王一东”5、use y2_19a.dbfCopy structure extended to c:s2_19a.dbf6、use s2_19a.dbfAppend from c:y2_19b.dbf7、use y2_19c.dbfCopy to c:s2_19b.dbf8、go bottomscatter to memvarappend blankgather from menvar9、use s2_19c.dbfrecall for PC=1110、use s2_19c.dbfDelete for between(T1,3,7)Pack2.51、go 7或者：goto 72、use s2_20d.dbfSort to c:s2_20dx on A1/A,A3/D,A6/A3、display fields XH,A1,书名,A6,A7 for A5=”大32” and recno()recount()-80或者：locate for A5=”大32” display fields XH,A1,书名,A6,A7 for recno()recount()-804、replace rest A7 with round(A7) for A1=.f.或者：locate for A1=.f. replace rest A7 with round(A7)5、use c:98sjkksml2y2_20a.dbfCopy structure extended to d:s2_20a.dbf6、use d:s2_20a.dbfAppend form c: 98sjkksml2y2_20b.txt delimited7、create c:s2_20b.dbf from c:98sjkksml2y2_20c.dbf8、use c:s2_20b.dbfgo bottomscatter to memvarappend blankgather from menvar9、 use s2_20c.dbfrecall for A1=”D”10、use s2_20c.dbfDelete for A650 and A690,”优秀”,iif(zf=60,”合格”,”不及格”) Endscan3注意：表间一对一，一对多关系中相应的索引字段及索引类型 提示的出错信息需用引号” 设置参数完整性时应注意选择要设置的相应父表子表3.28:有效性规则:BZGZ=2003.37:有效性规则:ZKZH=43.58:完整的messagebox()函数格式 Messagebox(“数据库3版本号为:”+str(dbgetprop(数据库3,database,version),0,”显示版本号”) 可参照课本P1159: 有效性规则:XH= 10或者:gl = 22 andWt = 10 orGl = 104.34. 筛选条件:DWMC like “湖北%” and YDRQ 90,”优秀”,IIF(ZF=60,”合格”,”不合格”) ENDSCAN8:表单的:borderstyle属性:”固定对话框” Caption属性: 考试8-78.48:成绩统计 命令 do p8_1.prg 成绩单 命令 do form T