下载
加入VIP
  • 专属下载特权
  • 现金文档折扣购买
  • VIP免费专区
  • 千万文档免费下载

上传资料

关闭

关闭

关闭

封号提示

内容

首页 填vf笔试空(Fill in VF written blank)

填vf笔试空(Fill in VF written blank).doc

填vf笔试空(Fill in VF written blank)

赵得道
2018-04-30 0人阅读 举报 0 0 暂无简介

简介:本文档为《填vf笔试空(Fill in VF written blank)doc》,可适用于社会民生领域

填vf笔试空(FillinVFwrittenblank)填vf笔试空(FillinVFwrittenblank)datainconsistencyreferstoAnswer:thesamedatahasdifferentvaluesindifferentapplicationsintheVFPsystem,thecommandisterminationeventloopAnswer:CLEAREVENTSAninformationmodeldesignmethodofpopularcalledERmethod,ERmethodforChinesemeaningAnswer:entityconnectionmethodifyouwanttoputatextboxobjectvalueissettothecurrentdate,inthetextboxoftheInitsetintheeventcodeforAnswer:THISVALUE=DATE()andThisformReleaseequivalentcommandsforAnswer:ReleaseThisformdatacanonlybeusedfortablesandnotformemoryvariablesAnswer:remarksandgeneralpurposeTheknownteachertable(JSDBF)containsaname(XM)for"WangYiping"record,performthefollowingprocedures,theoutputoftheSELEJSLOCATFORXM="WangYiping"XM=XMAnswer:WangYipingTheexpressionofXB=andthe"male"ORXB="female"equivalentforAnswer:XB$"menandwomen""theexpressionofSTR(YEAR(DATE)())thedatatypeisAnswer:Ctheknownteacherlist(JSDBF)hasbeenindexedbyname(XM)TheanswerisSEEK("WangYiping")Readthefollowingprocedures:SELEJSSETORDERTOXMSEEK'kings''IFFOUND()DISPLAYELSEWAITWIND'checkoutthismanENDIFIfyouwanttousetheSEEKfunctiontocompletethesamefunction,youshouldchangetheprogramtothesamefunction:SELEJSSETORDERTOXMIFDISPLAYELSEWAITWIND'checkoutthismanENDIFopentheitemAnswer:MODIFYPROJECTGrid,Text,CommandGroup,ColumnistheobjectintheVFPsystem,whichcannotbeapplieddirectlytotheobjectintheformisAnswer:ColumnTheclasscontainstheobjectprogramdesignanddataabstraction,hasthesamebehaviorabstractAnswer:objectwhenyouopenatableforanemptytable,thefunctionRECNO()thevalueofAnswer:TheknownN='',M='',X='GOOD',theexpressionvalueofXNMforAnswer:'GOOD'thefollowingsegmentisusedtofindthesumofevennumbersbetween~,sowriteitcomplete:N=S=DOWHILEN<=N=NIFN=ELSES=SNENDIFENDDOAnswer:LOOPcanopentheviewinthedatabasedesigner,canalsousetheUSEcommandtoopen,butbeforeusingtheUSEcommand,youmustopentheviewcontainsAnswer:Databasesupposetherearethreedatabasefiles:theanswer:SETDATABASETOMYDATAMYDATA,MYDATA,MYDATA,theyarestoredintheDDiskCDATAdirectory,DATAdirectory,aDATAdirectory,completethefollowingprocedures,aftertheexecutionoftheprogram,theDBC()functionvalueD:DATAMYDATADBCOPENDATABASEC:DATAMYDATAOPENDATABASED:DATAMYDATAOPENDATABASEA:DATAMYDATADBC()commoditydatabasecontainstwotables:commoditybasicinformationtableanswer:SPXXXSJ*XSQKXSSLANDTwoNonexistentDTOC(XSRQ)SPBH(SPXXDBF)andsalesstatement(XSQKDBF),Thetablestructuresareasfollows:Thecommoditybasicinformationtable|salestableStyleidSPBHC,|serialnumberLSHC,ProductnameSPMCC,XSRQD|saledateThepurchasepriceofJHJN,,|styleidSPBHC,ThesalespriceofXSJN,,|salesvolumeXSSLN,,RemarksBZMUsingtheSELECTSQLcommandtoquerythesalesinSeptember,Thename,salesvolumeandtotalsalesofvariouscommodities,fromsmallsalestosmallonesThebigsortofstatementis:SELECTSPXXSPMC,SUM(XSQKXSSL)ASsales,SUM()AStotalsalesFROMXSQK,SPXXWHEREXSQKSPBH=SPXXSPBHXSQKXSRQ={}INTOCURSORcXstmpGROUPBY(orSPMC)ORDERBYThetemporarytablecXstmpcannotusetheAPPENDorDELETEcommandforthistableAddordeleterecords,whentheUSEINcXstmpcommandisexecuted,thetemporaryTableToorderxsqkdbfinascendingorderbysalesdate,onsaledayInthesameperiod,theorderissortedbytheascendingorderofcommoditynumberscreateaformbasedonthespxxdbfandxsqkdbfprovidedbythepreviousquestionTheansweris:XSQK,SPXX,andtherelationshipbetweenthemSPXXSPBH,XSQKSPBH,SPXXXSJXSQKXSSL*SPXXXSJSingleentryforeachsalesbusinessFormdataenvironmentincludingThecommoditynumberintheformisacombobox,anditsRowSourceis,ControlSource,thesalespriceofthetextboxControlSourceEnterthesalesnumber,thenhittheEnterkey,atthistimeautomaticallydisplaytheamountofsales,thenTheValideventcodeforthesalesvolumetextboxis:(theamountofsalestextbox)TheNameattributevalueisTxtxseThisformTxtxseValue=opentheitemAnswer:MODIFYPROJECTGrid,Text,CommandGroup,ColumnistheobjectintheVFPsystem,whichcannotbeapplieddirectlytotheobjectintheformisAnswer:ColumnTheclasscontainstheobjectprogramdesignanddataabstraction,hasthesamebehaviorabstractAnswer:objectwhenyouopenatableforanemptytable,thefunctionRECNO()thevalueofAnswer:TheknownN='',M='',X='GOOD',theexpressionvalueofXNMforAnswer:'GOOD'thefollowingsegmentisusedtofindthesumofevennumbersbetween~,sowriteitcomplete:N=S=DOWHILEN<=N=NIFN=ELSES=SNENDIFENDDOAnswer:LOOPcanopentheviewinthedatabasedesigner,canalsousetheUSEcommandtoopen,butbeforeusingtheUSEcommand,youmustopentheviewcontainsAnswer:Databasesupposetherearethreedatabasefiles:theanswer:SETDATABASETOMYDATAMYDATA,MYDATA,MYDATA,theyarestoredintheDDiskCDATAdirectory,DATAdirectory,aDATAdirectory,completethefollowingprocedures,aftertheexecutionoftheprogram,theDBC()functionvalueD:DATAMYDATADBCOPENDATABASEC:DATAMYDATAOPENDATABASED:DATAMYDATAopendatabase:mydatadatedoc()商品数据库中含有两个表:商品基本信息表答案:spxxxsj*xsqkxssland不存在dtoc(xsrq)spbh(spxxdbf)和销售情况表(xsqkdbf)表结构分别如下:商品基本信息表|销售情况表商品编号spbhc,|流水号lshc,商品名称spmcc,|销售日期xsrqd进货价jhjn,|商品编号spbhc,销售价xsjn,|销售数量xsslno,备注bzm用selectsql命令实现查询年月日所销售的各种商品的名称、销售量和销售总额,并按销售量从小到大排序的语句是:selectspxxspmc,sum(xsqkxssl)as销售量,sum()as销售总额fromxsqk,spxxwherexsqkspbh=spxxspbhxsqkxsrq=(}intocursorcxstmpgroupby(或spmc)orderby临时表cxstmp不能使用append或delete命令对该表添加或删除记录,当执行useincxstmp命令后,该临时表将如果要对xsqkdbf按销售日期升序排序,在销售日期相同的情况下,按商品编号升序排序,则索引表达式为根据上题提供的spxxdbf和xsqkdbf创建表单,该表答案:xsqk、spxx及它们之间的关系spxxspbh,xsqkspbh,spxxxsjxsqkxssl*spxxxsj单用来录入每笔销售业务表单的数据环境包括表单中商品编号为组合框,它的rowsource为,controlsource为,销售价文本框的controlsource为输入销售数量以后打回车键,此时自动显示销售金额,则销售数量文本框的valid事件代码为:(销售金额文本框的name属性值为txtxse)thisformtxtxsevalue=选项按钮组是对象,它的value属性表明用户选定了哪个按钮假定现有一个选项按扭组有六个选项按钮,该选项按钮组的controlsource属性值是一个整型字段,如果用户选择了第四个按钮,则选项按钮组的value属性值为答案:容器,利用查询设计器设计查询,可以实现多项功能,查询设计器最终实质上是生成一条语句答案:selectsql组合框的数据源由rowsource属性和rowsourcetype属性给定,如果rowsource属性中写入一条selectsql语句,则它的rowsourcetype属性应设置为答案:查询某表单中有一"下一记录"的记录定位命令按钮cmdnext,请完成该按钮的click事件代码:(假定该表单所用到的表为xsdbf)selectxsifeof()gobottomthis让该按钮不响应用户操作elserefreshthisformendif答案:skipenabled=f设jsdbf及jsrkdbf的结构如下:答案:jsgh=jsrkghOneFourVALUETeacher'steacher'sscheduleFieldnametypewidthmeaningfieldnametypewidthmeaningGHCNoGHCnumberNAMECnameKCHCcoursenumberXBCgenderKCMCCcoursenameThenameofXIMTCKSSNhoursAndbuildcompositeindexforGHrespectivelyTheirexistingdataareasfollows:Teacher(JSDBF)Name,genderandtitleofworknumberDepartmentofmalemanagementengineering,ChenZiliangZhaoDongpingDepartmentoffemaleManagementEngineeringWangYipingmaleComputerDepartmentChenZhiminmaleChineseDepartmentTeacher'sschedule(JSRKDBF)NumberofclassnumberofcodecoursenamecomputerizedaccountingcurriculumdesignofaccountingcomputerizationsoftwareengineeringCcomputerizedaccountingChineseliteratureThefollowingcommandsareusedtoquerythetotalnumberofclassesforeachteacherPleasewriteitThewhole:SELECTjsgh,jsxm,SUM(jsrkkss)AStotalclasshourFROMJS,JSRKWHEREINTOCURSORcJsrkzstmpGROUPBYORDERBYGHArecordnumberoftemporarytablecJsrkzstmpforCompletethefollowingcommandstoinsertanewrecordintotheJSRKtableandrecorditThecontentsare:''(worknumber),''(coursecode),'computer'Introduction(coursename),(classhours)INSERTINTOjsrk(GH,KCH,kcmc,KSS)('','','computer',)ifthetitleJSRKDBFrankingaccordingtothenumberintheindustry,fromsmalltolarge,equal,accordingtothecoursenumberofsmalltolargeorder,theindexexpressionisAnswer:GHKCHthestructureandcontentoftheknownteacherlist(JSDBF)areshownintheitem,andreadthefollowingprocedure:answer:,N=M=SELEJSSCANWHILEXB='men'N=NENDSCANM=RECCOUNT()N**RECCOUNT()isastatisticalrecordfunctionTheimplementationoftheprogram,N,Mrespectively,thestructureoftheknownteachersalarytable(JSGZDBF)isasfollows:VALUEMale,femaleJSGZXBWorknumber(GH)C,Name(XM)C,Sex(XB)C,Basicwage(JBGZ)N,Positionwage(ZWGZ)N,Bonus(JJ)N,AddtheaboveJSGZDBFtothedataenvironmentoftheform,andcreatetheform:Whenyoupresstherealisticwagebutton,theactualwageoftheemployeeisshownThevalueoftheNAMEpropertyofthetextboxthatshowstheactualwageisTxtsfgzThecodefortheClickeventofthebuttonisasfollowsPleasewriteitcomplete:LocallnsfgzLnsfgz=jsgzjbgzjsgzzwgzjsgzjjThisParentTxtsfgz=lnsfgzThisformrefreshThegenderintheformissettoacomboboxifitsRowSourceTypeissetThevalueof,itisRowSourcefor,thetextboxControlSourcethefollowingprocedureisusedtofindtheareaoftherectanglePleasewriteitcompletely:X=Y=S=AREA(X,Y)SFUNCTIONAREAS=X*YRETURNTheanswer:PARAMETERSX,YSTheexpressionisthevalueof{}{}ExpressionINT()*ROUND)(,)valueisforthedataboundcontrol,controlanddatasourcetobindtheattributesetAnswer:ControlSoureperformthefollowingproceduressection,X(,)andX(,)valuesforrespectivelyTheprogramlistisasfollows:DIMENSIONX(,)X=Answer:fortheVisualFoxProsystemrestorecommandmenubydefaultinthemainmenusystemisAnswer:SETSYSMENUTODEFALUTcannotcreateindexwithandgeneralfieldstructureindexexpressionAnswer:memotypeIfyouwantaoptionbuttononthesetto,theOptionGroupattributevalueissettoAnswer:ButtonCountusestheobjectorientedprogrammingmethodtodesigntheapplicationprogram,therealizationofitsfunctionisdrivenbyAnswer:EventsVFPsystem,opentheprojectfileisAnswer:MODIFYPROJECTTheobjectisexamplesAnswer:Classopenanemptytable,thefunctionEOF()thevalueofAnswer:Tdatabasetablescanbeprovidedwithalongtablename,butthefilesstoredonthediskisAnswer:tablenameiftheinserttriggerofthedatabasetableissettoF,whenanemptyrecordisinsertedintothetable,thescreenisdisplayedAnswer:triggersfailedcomboboxwithadropdownlistboxandfunctionAnswer:textboxintheSELECTSQLstatement,theDISTINCToptionisAnswer:excludeallduplicaterowsinthequeryresultinaform,aOLEboundcontrolusingtypefieldinthetableshowsaOLEobjectAnswer:generalpurposeTheknownN='',M='',X='good',theexpressionvalueofXNMforAnswer:'GOOD'thefollowingprocedureisusedtofindthesumof~evennumbersPleasewriteitcomplete:N=S=DOWHILETIFN>ELSES=SNENDIFN=NENDDOAnswer:EXITlocalviewofthetablewithviewopenautomaticallyopenandclose,butnotwiththeviewoftheclosedTheansweris:BaseintheVFPsystem,thesamepropertyofmultipleobjects(suchasthewidthattribute)canalsosetthesetbefore,mustalsotheseobjectsAnswer:Selectedthefollowingcommand,thevalueofSisS='ABCD'S='EFG'S=ALLT(S)ALLT(S)S=SUBSTR(S,,)answer:'EF'answer:D:DATAMYDATADBCSupposetherearethreedatabasefilesMYDATA,MYDATA,MYDATA,andtheyareCwerestoredintheDATAdirectory,DATAdirectoryoftheDdisk,adiskDATAdirectory,afterexecutingthefollowingprogram,thevalueofDBC()functionisOPENDATABASEC:DATAMYDATAOPENDATABASED:DATAMYDATAOPENDATABASEA:DATAMYDATASETDATABASETOMYDATADBC()Therearetwotablesinthecommoditydatabase:thebasicinformationtable:VALINDTOC(XSRQ)SPBH(spxxdbf)andsalesstatement(xsqkdbf),tablestructureisasfollowsAndthespxxtablehasalreadyestablishedthestructurecompoundindex,TheindexexpressionisspbhSalesinformationofcommoditybasicinformationtable(spxxdbf)Xsqkdbf)DubbedspbhC,LSHCserialnumber,SixCommoditynameSPMCC,salesdateXSRQDPurchasepriceJHJN,,commoditynumberSpbhC,SalespriceXSJN,,salesquantityXsslN,,RemarkBZMsalesamountXSEN,,)Intherecordisaddedtothesalestable,theautomaticserialnumberplus,lessthanthemedianofthefieldwidthoftheserialnumber,inthestring""charactertomakeup,suchas""""afterthe""ThefollowingprogramsegmentisusedtocompletetheabovefunctionPleasewriteitcomplete:SELECTMAX(LSH)FROMxsqkINTOCURSORCMaxlshtmpLOCALlcMaxlsh,lcNextlshLcMaxlsh=cMaxlshtmplshandfindoutXsqktablenumberLcNextlsh=(lcMaxlsh)andaflowThewaterinthemaxplusINSERTINTOxsqk(LSH)VALUE(PADL(lcNextlsh,,''))USEcMaxlshtmpandwillbetemporaryTimetableclosed)ifthexsqkdbftableissortedbythedateofsaleinascendingorder,thedateofsaleundertheconditionofthesamesortbycommoditynumbersinascendingorder,theindexexpressioniscreatethefollowingformbasedonthespxxdbfandxsqkdbfprovidedbytheabovequestionTheansweris:SPXXSPBH,XSQKXSSLSPBHSPXXXSJ*XSQKXSSLTAThisformisusedtoentereverysalesbusinessIntheformofcommoditynumbersforthecombobox,itisRowSourceThenumberofsalesfortheControlSourcetextboxWhenthegoodsnumberchanges,theamountofsalespriceandsalesalsochangesaccordingly,thecomboboxintheformofthecodefortheInteractiveChangeevent:Name(propertypriceandsalesamountofthevalueofthetextboxrespectivelyTxtxsj,Txtxse)LocallcspbhLcspbh=ThisValueSEEKlcspbhORDERINspxxThisformTxtxsevalue="blog"ThisformTxtxsjRefreshTheformdataincludexsqkdbf,spxxdbfandtherelationshipbetweenthem,andthexsqkdatabuffertableforopenlinebufferrequirements,whenyoupresstheSavebutton,therealinputdatawrittenintothexsqktable,ClickeventcodebuttoninadiskcontainingafunctionAfterrunningthefollowingprocedures,thefirsttwobehaviordisplaycontent:,programsegmentlistSET"TALKOFF"S='ABCDEF'N=LEN(S)K=DOWHILEK<=NSUBS(S,K,NK)K=KENDDOAnswer:'ABCDE','BCDE''InVFPsystem,terminationeventcommandsare:cycleAnswer:CLEAREVFNTOOPChinesemeaning:Objectorientedprogrammingdataprocessingisaprocessofonalltypesofdata,classification,calculation,processing,retrievalandtransmissionAnswer:collectionandstoragedatabasegenerallyrequireaminimumredundancyreferstodataasmuchaspossibleresourcedatabase,thedatabaseisinanoptimalwaytoserveoneormoreapplicationsAccordingtothedataofdatabase,datastorageasindependentaspossibletotheapplicationusingitAnswer:norepetitionShareIndependentSixtyeightTheexpressionofSTR(YEAR(DATE)())thedatatypeisAnswer:CprojectmanageristhefunctionoftheorganizationandmanagementofallprojectrelatedtypesofAnswer:fileinthedatabasesystem,thebasicstructureofrelationmodelisaAnswer:twodimensionaltableaccordingtothedatamodelusedtobelongtoVFP,databasemanagementsystemAnswer:relationalChinesemeaningEnglishabbreviation"DBMS"isDBMSismainlycomposedof,storagemanagerandthetransactionmanageriscomposedofthreepartsAnswer:databasemanagementsystemquerymanagercheckboxcontrolscanbedividedintothreestates,theValueattributevaluesareF,TorAnswer:useprintdatainatable,intherelevantreportandtablefieldscontrolsinthereportzoneAnswer:Detailsifyouwanttodeletedeleterecordswithphysicalsigns,canusethecommand,butintheexecutionofthecommandbeforethetablemustbeopentowayAnswer:PACK,monopolyVisualFoxProsystem,thetriggertableisboundinthetable,whenanyentriesinthetablearedesignatedcommandmodifiedwhenthetriggerisactivatedAnswer:expressionfromthetwodimensionaltableaftertheelectiontochooseakeyword,canbeusedasKeykeywordsThestructureofXS(student)tableis:TABLEXSZZMMLTypelengthoffieldnameXHstudentIDXMnamecharactersXBgendercharacterCSRQbirthdateThelogicofZZMM'spoliticalsituationBZremarksThefollowingcommandsareusedtocreatethestructureoftheXStable,sopleasemakeitperfect:CREATE(XHC(),XMC(),XBC(),CSRQD,,BZM)knownstudentachievementtable(CJDBF)containsstudentnumber(XH,C,),curriculumcode(KCDH,C,)andscores(CJ,N,)fieldInordertoevaluateeachgrade(excellent,good,pass,fail),inthedatabasewherethetableiscreated,accordingtothescorescorestoevaluatetheperformanceleveloftheuserdefinedfunctionanswer:CddGETDD,thecodeforfunctionGETDDisasfollows:FUNCTIONGETDDPARAMETERSnCjLOCALCDDCdd=""DOCASECASEnCj>=Cdd="excellent""CASEBETWEEN(nCj,,)Cdd="good""CASEBETWEEN(nCj,,)Cdd=passedtheexam"CASEnCj<Cdd="failed""ENDCASERETURNNote:thefunctionofVisualFoxProsystemfunctionBETWEEN()istojudgewhetherthevalueofanexpressionisbetweenthevaluesoftheexpressionsoftwoidenticaldatatypesalistofthemainkeywordsareincludedinanothertable,inanothertablereferredtointhesefieldsAnswer:externalkeywordsacolumninatablecalled,itspecifiesthecharacteristicsofdataarowinatableiscalleda,itisacollectionofmultiplefieldsEachfieldmusthaveaattributetoidentifythefieldAnswer:field,recordfieldnameTableextendeddocumentcalledthe,ifthetablestructurecontainsthefieldtypeortype,willresultinanextensionofthememofileAnswer:DBFRemarks,generalpurposeFPTtableofknownscores(cjThetablestructureofDBFisasfollows:answer:FieldnametypewidthmeaningXHCstudentnumberQZN,,inwhichscoresQMN,finalresultsTherearerecordsinthetable,arrangedasfollowsinthephysicalorderofinput:XHQZQMThetablehascreatedastructuredcompositeindexasfollows:IndexsequentialindexnameindexexpressionDescendingCJAQZQMAscendingorderCJBSTR(QZ)STR(QM)Executethefollowingcommands:USECJORDERTAGCJABROWSEInthebrowsewindowschoolnumber""recordsshowthatinthelineIfthecommandisexecutedinthecommandwindow:SETORDERTOTAGCJBBROWSEInthebrowsewindownumberforthemiddleschoolrecordsshowthatinthefirstlineintheformofLoad,ActivateandInitofthesethreeevents,eventscannotreferenceobjectformandtheeventlasttriggerAnswer:ACTIVATEthereisafrmAform,theformcontainsapageframepgfB,thenumberofpagescontainingthepageunknownbox,intheformofallthepagestorefresh,refreshapageinthebox,thepreparationofaFORloopstructurecodeREFRESHmethodinframepgfB,pleasecompletethefollowingcode:FORi=toThisThisPagesirefreshENDFORAnswer:PAGECOUNTcallsystemdialogboxsystemfunctionMessageBox()syntaxisasfollows::MESSAGEBOX(cMessageText,nDialogBoxType,CTitleBarText)Parameter:CMessageTextisacharactertypeparameter,whichisspecifiedinthedialogboxTextNDialogBoxTypeisanintegerparameterthatspecifiesthebuttonsinthedialogboxThedefaultbuttonanddialogboxbehavioroficons,displaydialogboxesInthenextInthetable,thedialogbuttonvalueisspecifiedfromtointhedialogboxButtonIconvalues,,specifythediagraminthedialogboxStandardCTitleBarTextisacharactertypeparameter,specifyingthetitlebarinthedialogboxTextNumericdialogbuttonvaluesIcononly"OK""stop"Icon"determine"and"Cancel""*"Shit*Icon"giveup","retry"and"ignore""exclamationmark"mark"yes","no"and"Cancel""*"Bank*(I)Icon"yes"and"no"""retry"and"cancel""ThereturnvalueoftheMessagebox()functiondependsonthebuttonselectedbytheuser,andthereturnvalueisshowninthetablebelow:ButtontocancelretryandignorewhethertoreturnvalueThedialogboxshownontherightappearsinanapplicationduringexecution:Accordingtotheinformationdisplayedinthedialogbox,completethefollowingprogramsegment:LocalnSelectNSelect=MessageBox("delete",",deleteConfirm""IFnSelect=SELECTJSDELETEENDIFIfinthedialogboxselect"no",thenthevalueofthevariablenSelectisknownteacherstableJSDBF(includingfield:worknumber(GH,C,),nameAnswer:AVG(jbgz)asaveragewageWHEREximing='informationmanagementdepartmentGROUPBYXiming(XM,C,),basicwage(JBGZ,N,,),departmentname(XIMING,C,)CompletethefollowingSQLcommands,andcounttheinformationtubesintheJStableTheaveragewageofworkersandstaffmembersTheSQLcommandisasfollows:选择FROMJS为小人jstmp。答案:ALLT(STR(n))ENDSCAN已知学生成绩表(CJDBF)的结构由学号(XHC)、课程代号(kcdhC)和成绩(CJn)三个字段组成下面程序段用来检查表中的CJ是否小于如果小于给出提示信息。例如:如果第条记录的成绩小于则显示提示信息为:“第条记录的成绩录入不合法”。完善下列程序段使它完成上述功能:使用CJ扫描如果CJ<n=recno()S=“第”“条记录的成绩录入不合法”WAITSENDIF*****一。表、数据字典*****答案:银行存款”表(CKDBF)的表结构字段组成为:答案:创建表的CK(ZHC()空crrqDCQN(,)詹妮)ALTERTABLECK添加列并购修改表结构BZ添加空白帐号(ZHC)存入日期(crrqT)存期(CQN,)金额(JEy)要求写出创建CK表的SQL语句。为该表增加一个备注型字段BZ的命令是。增加一条空记录的命令是。。在JS表中要删除所有工龄(字段名GL)大于的记录的SQL命令是删除JS要彻底删除这些记录可用命令但这一命令的实施必须要求表以方式打开。答案:FROMgl>PACK独占

用户评价(0)

关闭

新课改视野下建构高中语文教学实验成果报告(32KB)

抱歉,积分不足下载失败,请稍后再试!

提示

试读已结束,如需要继续阅读或者下载,敬请购买!

文档小程序码

使用微信“扫一扫”扫码寻找文档

1

打开微信

2

扫描小程序码

3

发布寻找信息

4

等待寻找结果

我知道了
评分:

/32

填vf笔试空(Fill in VF written blank)

VIP

在线
客服

免费
邮箱

爱问共享资料服务号

扫描关注领取更多福利