access-命名規(guī)則-資料下載頁
2025-08-09 16:05本頁面
【正文】 ubledblDim dblPi As DoubleDynasetdynDim dynTransact As DynasetFlag (Y/N, T/F)fDim fAbort As IntegerFieldfldDim fldLastName as FieldFormfrmDim frmGetUser As FormGroupgruDim gruManagers as GroupIndexidxDim idxOrderId as IndexIntegerintDim intRetValue As IntegerLonglngDim lngParam As LongObjectobjDim objGraph As ObjectParameterprmDim prmBeginDate as ParameterPropertyprpDim prpUserDefined as PropertyQueryDefqdf (or qrd)Dim qdfPrice As QueryDefRecordsetrec (or rst)Dim recPeople as RecordsetRelationrelDim relOrderItems as RelationReportrptDim rptYTDSales As ReportSinglesngDim sngLoadFactor As SingleSnapshotsnpDim snpParts As SnapshotStringstrDim strUserName As StringTabletblDim tblVendor As TableTableDeftdf (or tbd)Dim tdfBooking as TableDefType (userdefined)typDim typPartRecord As mtPART_RECORDUserusrDim usrJoe as UserVariantvarDim varInput As VariantWorkspacewrk (or wsp)Dim wrkPrimary as WorkspaceYes/No18ysnDim ysnPaid As Integer在我們的命名方式中，不使用$ 和 %這些數(shù)據(jù)類型前綴，因?yàn)樵贏CCESS和Visual basic的文檔中是不推薦使用這些前綴的象窗體和報(bào)表這樣的數(shù)據(jù)庫對(duì)象變量的標(biāo)記符是與數(shù)據(jù)庫對(duì)象的標(biāo)記符是一樣的，這樣命名有助于編程，因?yàn)橥ǔＤ惴峙浣o一個(gè)變量的名稱（如tblVendor）與它所引用的對(duì)象（tblVendor）有同樣的名稱，這樣就會(huì)在編程中提供統(tǒng)一的對(duì)象2.常量和自定義數(shù)據(jù)類型使用大寫名字作為常量，這是WINDOWS編程的一種習(xí)慣，3.范圍前綴命名級(jí)別2中引入了變量和常量的范圍前綴的概念，范圍放在其它所有前綴的前面 ?局部定義的變量沒有前綴 ?局部定義的靜態(tài)變量前綴為 s, 例如 sintAccumulate. ?在模塊聲明節(jié)里（或窗體代碼）定義的變量使用m作為前綴，例如 mcurRunningSum. ?使用 Global 定義的全局變量使用前綴 g, 例如 glngGrandTotal. ?作為函數(shù)或子程序參數(shù)傳遞的變量 (函數(shù)名稱后面的圓括號(hào)里) 使用前綴 p, 例如 pstrLastName. 另外, 當(dāng)在一個(gè)函數(shù)定義部分形參和值參都存在時(shí)，我們有時(shí)也使用 r 而不是 p 來指明是形參, 用 v 來指明是值參,。?對(duì)象名稱后面的限定符進(jìn)一步區(qū)分那些意義很接近的對(duì)象. 你可能已經(jīng)針對(duì)各類應(yīng)用設(shè)計(jì)了自己的一系列限定符，不過，下表中有些通用的限定符變量屬性限定符例子Current element of setCuriaintCurFirst element of setFirstiaintStockFirstLast element of setLastiaintStockLastNext element of setNextstrCustomerNextPrevious element of setPrevstrCustomerPrevLower limit of rangeMiniastrNameMinUpper limit of rangeMaxiastrNameMaxSourceSrclngBufferSrcDestinationDestlngBufferDest
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1