资源描述：
《osta--vfp题库相关命令参考答案》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、注意：若表已自动打开，则不需要使用use命令打开2.11、editfields编号,姓名,职称,讲课工作量,讲课酬金for授课班级=”94公路_2”或者：locatefor授课班级=”94公路_2”edit2、goto5displaynext6fields姓名,系名,授课班级,授课人数,课时3、copystructuretoc:s1_1a.dbf4、goto20replacerest讲课工作量withint(课时*授课人数/20)5、appendfromc:y2_1b.dbf6、gobottomscattertomemvarappe
2、ndblankgatherfrommenvar7、recallfor系名=”经济系”8、listfordelete()9、sorttos2_1dx.dbfon职称/A,授课人数/D2.21、goto2displayrestforGZRQ<={^1990/12/31}或者displayrestforYear(GZRQ)<19912、sorttoc:s2_2dx.dbfonDWDH/A,GZRQ/D3、goto30replacerestSHPTwithint(SHPT)4、browsefields##,BZGZ,BQ,KZ5、copyst
3、ructuretoc:s2_2b.dbf6、appendfromc:y2_2b.txtdelimited7、gobottomscattertomemvarappendblankgatherfrommenvar8、recallforsubstr(xm,1,2)=”张”9、recallall10、deleteforBZGZ>100.00Pack2.31、changeforZY=”学生”2、listfields姓名,NL,F1,F2,F3forXL=”大专”orXL=”大学”或者displayallfields姓名,NL,F1,F2,F3
4、forXL=”大专”orXL=”大学”3、goto20replacerestZFwithsqrt(560)4、菜单操作，追加记录，数据表已打开：a选择“表”菜单/追加记录（A）b在出现的“追加来源”对话框中做相应设定：类型：delimitedtext来源：y2_7b.txtc点击“确定”按钮即可( 注：类型和来源要根据题目的要求来定)5、usey2_7d.dbfCopytoc:y2_7c.dbfUsec:y2_7c.dbfRecallforXL=”初中”6、deleteforZY=”干部”andyear(NN)<1997pack7、
5、usey2_7e.dbfCopytoc:s2_7d.dbfUsec:s2_7d.dbfSorttoc:s2_7dx.dbfonNL/D,SFZH/A2.41、uses2_19.dbfEditforsubstr(xm,1,2)=”张”或者：locateforsubstr(xm,1,2)=”张”edit2、uses2_19d.dbfsorttoc:s2_19dxonZKZH/D,PC/D,T1/A3、displayfieldsZKZH,XM,F5,F6forT2=”2”andrecno()>recount()-70orT3=”3”a
6、ndrecno()>recount()-704、replaceXMwith“王一东”forlen(XM)=4或者：locateforlen(XM)=4ReplaceXMwith“王一东”5、usey2_19a.dbfCopystructureextendedtoc:s2_19a.dbf6、uses2_19a.dbfAppendfromc:y2_19b.dbf7、usey2_19c.dbfCopytoc:s2_19b.dbf8、gobottomscattertomemvarappendblankgatherfrommenvar9、u
7、ses2_19c.dbfrecallforPC=1110、uses2_19c.dbfDeleteforbetween(T1,3,7)Pack2.51、go7或者：goto72、uses2_20d.dbfSorttoc:s2_20dxonA1/A,A3/D,A6/A3、displayfieldsXH,A1,书名,A6,A7forA5=”大32”andrecno()>recount()-80或者：locateforA5=”大32”displayfieldsXH,A1,书名,A6,A7forrecno()>recount()-804、rep
8、lacerestA7withround(A7)forA1=.f.或者：locateforA1=.f.replacerestA7withround(A7)5、usec:98sjkksml2y2_20a.
