vfp程序設(shè)計(jì)模擬試卷六及答案

《vfp程序設(shè)計(jì)》模擬試卷六及答案(VFPprogramdesignsix

simulationpapersandanswers)2006secondaryoccupationschoolexaminationVISUALFOXPROpaperBFirst,fillintheblanks(50points,2pointseach)1,createareportmethod.2,VisualFoxPro6isadatabasemanagementsystem.In3,VFPindexisdividedintofourkinds,and.In4,VisualinFoxPro,thearraysubscriptisfromthebeginning.5,thefieldvaluesarenotallowedtorepeat,andonlyonetabletocreateanindexindex.Theprogramstructureof6inVFP,3,respectively,,.In7,VisualFoxPro6,thedatatableisdividedintotwokindsand.inVFP,areferencetoobjectreferencesandreferencestwo.usingVFPinabsoluteandrelativemobilecommandmovecommandcanmovethepointerinthetable.VisualFoxPro,tocreateadatabasetablefileshouldbeselectedinthedesigner.theobjectistheobjectcanperformitsactionorbehavior.byanumberoflocaldatatabletocreatetheview,shouldbecalled.queryandupdatedatainadatatable.thequerydesigner"field"tab,selectcontrol.viewandquerycanbeoperatedonthetable.inSQL,createuniqueindextousereservedwords.TheobjectofMyformlform17,intheprogramtoshowwhathasbeencreated,shouldusethecommand.Two,choice(atotalof30points,2pointsforeachitem)nomatterwhethertheforceindex,positioningtothesamerecordcommandis().AGOTOPB)GO)BOTTOMC)GOD)SKIP6maybeaccompaniedbyatableandopenautomaticallyopenindex().singleindexfile(IDX)B)compositeindexfile(CDX)C)structuredcompositeindexfileD)unstructuredcompositeindexfiletoincreasethewagesof100yuanshouldusethecommandforthecurrenttable(staff).A+100CHANGEWITH)paywagesB+100REPLACEWITH)paywagesC+100CHANGEALLWITH)paywagesD+100REPLACEALLWITH)paywagesVisualFoxProreferentialintegrityrules(notincluded).updateruleB)queryruleC)deleteruleD)insertionrulesinthedatabasedesigner,toestablishtherelationbetweenthetwotablesisachievedbythefollowingindex.()A)a"party"tableofthemainindexorcandidateindex,"multitableindex"the"mainindexone"table,"many"tableindexorcandidateindex"generalindexone"table,"fromthe"tableofthemainindexorcandidateindex"acommonindex"table,"Many"candidateindextableorindexifyouwanttoseetheresultsdirectlyonthescreen,"checkthewhereaboutsof"shouldchoose().A)B)C)screenbrowsetemporarytableorbrowseorscreenscreenD)usingthemenuoperationmethodtoopenanalreadyexistsinthecurrentdirectoryqueryfileafterzgjk.qprinthecommandwindowcommandisgenerated().AOPENQUERYzgjk.qpr)BMODIEYQUERYzgjk.qpr)CDOQUERYzgjk.qpr)DCREATEQUERYzgjk.qpr)describedbelowaboutVisualFoxProarray,theerroris().A)withDIMENSIONandDECLAREcandefineanarrayonlyone-dimensionalarrayandtwo-dimensionalarrayVisualFoxProallthearrayelementsinanarraymustbeofthesametypeofdataD)eacharrayelementinitialnewdefinitionfor.F.inthefollowingfunction,functionofnumericalvalueis().A(AT)'people','People'sRepublicofChina')(B)CTOD'01/01/96')C(BOF))D(SUBSTR)(DTOC)(DATE),7)inVisualFoxPro,generalfieldGandMmemofieldsinthetablewidthis().A)2bytesofB4bytes)C)8bytesofD10bytes)ofreferentialintegrityissetinVisualFoxPro,toseta:whenchangingtheparentkeyfieldfortheprimarykeyfieldorinthecandidatelist,automaticallychangeallthevaluesinthecorrespondingrecordtable.Shouldchoose().A)(Restrict)B)ignorethelimit(Ignore)C(Cascade)D))cascadecascade(Cascade)orLimited(Restrict)intheVisualFoxProdatawindow,usetheSETRELATIONcommandtoestablishtheconnectionbetweenthetwotables,thisassociationis().A)permanentassociationB)permanentortemporaryAssociationAssociationC)temporaryassociationD)permanentandtemporaryAssociationAssociationtoclearthemainwindowscreencommandis().A)CLEARB)CLEARALLCCLEARSCREENDCLEARWINDOWS))inthecreationofquickreport,basiczone(including).A)title,detailsandsummaryB),detailspageheaderandpagefooterC)groupheader,detailsandgroupD)footnotetothereporttitle,detailsandpagesoffootnotessaveVisualFoxProreportfilesin.FRX(is).A)printpreviewBformat)toprintthereportitselfC)reportformatanddataD)defineareportformatdesignThree,determinethetitle(20points)canusethequickreportfunctiontoaddmorethanonetableinthefieldtothereportdesigner.()reportdesign,undofunctioncanundoseveraltimesinfrontoftheoperation.

()openthefile,theVisualFoxProindexfilewillautomaticallyopenthetable.()reportdatasourcescanbeatable,butnottheview.()alldataoutputstatementsarestoredinthereportfile.()thearraymustbedefinedatfirst,aftertheassignment.()7,useMODIFYCOMMANoDcreatetheprogramfile7,useMODIFYCOMMANoDcreatetheprogramfileisatextfile.()openthetable,thecurrentrecordisthefirstrecord.()inthemultibranchselectionstructureprovidesachoice,andthereisonlyoneoptionisexecuted.()datainformation,informationanddata.()In11,thecyclestructureoftheprogram,thebodyofthestatementisexecutedatleastonce.()12,theuseofDO<program|process>[WITHparametertableisvariableparameterscanonlytransfer.()13,themenuisdefinedwithstorageformfile.()Haveavalueandadatatype14,amemoryvariableatanyonetimeonly.()arewhenthequeryisrun,thesystemdefaultqueryresultsdisplayedonthescreen.()arethequeryandviewcanoutputdatainthebrowsewindow.()querytwotablesofdata,betweenthetwotablescannotestablishaconnection.()thenewqueryquerydesigner,onlytosavethequery,torunthequery.()freetableanddatabasecannotbetransformedintoeachother.()adatabasetab