全国计算机VFP二级考试备考资料

《全国计算机VFP二级考试备考资料》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

.....................................................┯஺ᭆ........................................┯஺VFP.............................................................................................................1VFPḄᦪஹ!"#$.......................................6%ᦪ&"ᐸ()...................................................17*SQL+,.........................................................32-./012........................................................4134567Ạ......................................................449⊤ᓫ670<ᵨ...................................................54>?ᓫ670<ᵨ...................................................70ᓝA⊤67..........................................................73ᓝᦪ&<ᵨBCḄD...........................................76

1ᐰF7$GHVFPᜓὃKᧇ2010—7-16Rebuilding᦮ᳮᦪ&BCẠOP1.1ᦪ&BCᭆR1.1ᦪ&ẠOP1ᦪ0ᦪᜐᳮᦪTᢣVWᙠYZ[\]^_P`Ḅᱥᳮbc஺ᦪᜐᳮḄdef⚪Tᦪhᳮ஺27$Gᦪhᳮ(1)lmhᳮ஺(2)ᦻoBC஺(3)ᦪ&BC஺(4)ᑖsᦪ&BC஺(5)☢ᔣwxᦪ&BC஺3ᦪ&hᳮBCyᦪ&Ḅz{ஹ|ᵨ}~Ḅoyᦪ&hᳮBCDBMS(DataBaseManagementSystem)஺2ᦪ&BC1ᨵᐵᦪ&Ḅᭆ(1)ᦪ&(DataBase)VWᙠ7$GVW6ᜓ]ஹ᪀ᓄḄᐵᦪḄᔠ஺(2)ᦪ&<ᵨBC(DBAS)TᵫBCDlᕒᑭᵨᦪ&BCKDᩭḄ¡☢ᔣY¢▭<ᵨḄ<ᵨoBC஺(3)ᦪ&hᳮBC(DBMS)wᦪ¢¤¥¦hᳮ¡§¨©ᐰឋ}«᦮ឋ¬CGᑴ¡®¯wᦪ&Ḅz{ஹ|ᵨ}~¤hᳮ஺(4)ᦪ&BC(DBS)Tᢣ°ᦪ&ᢈ²³Ḅ7$GBC¡¢´ᨵµ¶ᙢஹ¸᝱ᙢVWᜧ»ᐵᦪ¡§¨ᦪᜐᳮ}¼½Kᐳ¿ḄÀᑭÁÂ஺ᦪ&BCᵫÃoBCஹᦪ&ஹᦪ&hᳮBC"ᐵoஹᦪ&hᳮᕒ}ᵨᡝ¬Åᑖµᡂ஺2ᦪ&BCḄᱯÈ(1)¢´ᦪᐳ¿¡ÉÊᦪᑍÌ஺(2)ÍᵨᱯḄᦪÎ!஺(3)ᐹᨵÐÑḄᦪÒ{ឋ஺(4)ᐹᨵCḄᦪÓᑴÔ^஺3ᦪÎ!1¢\ḄÕR(1)¢\஺(2)¢\ḄÖឋ஺(3)¢\}¢\!஺

2ᐰF7$GHVFPᜓὃKᧇ2010—7-16Rebuilding᦮ᳮ2¢\×ὶB"ὶBḄZ(1)wὶB஺(2)wÙὶB஺(3)ÙwÙὶB஺3ᦪÎ!ÚÛyÜÝ᧜ßᱥà"ßᱥá×ḄᔜZὶB¡ᦪ&dḄᦪãäᨵḄ᪀¡åZ᪀ᵨᦪÎ!ᩭ⊤æ¡çèᨵ¯é3Z஺(1)êëᦪÎ!஺(2)ìíᦪÎ!஺(3)ᐵBᦪÎ!஺î§æᦪ&DBஹᦪ&BCDBS}ᦪ&hᳮBCDBMSá×ḄᐵBTDBSᒹðDB}DBMS஺1.2ᐵBÎ!ᐵBÎ!Ḅᵨᡝñ☢òèÚᓫ¡óᐵBḄôõ᪀öT÷~⊤஺åZᵨ~⊤Ḅ⊤æ¢\}¢\×ὶBḄᦪÎ!yᐵBᦪÎ!஺(Gᐵ:óᐵBöT÷~⊤¡úóᐵBᨵóᐵBû஺ᙠVisualFoxProᐵᦻ᡽DBF,“⊤”஺ᐵḄᐵ!ᐵ!"ᐵḄ#᪀%!&ᐵ((ឋ1,(ឋ2,…(ឋn)(2)ᐗ0&ᙠ23⊤456ᔣḄ8ᐗ098ᐗ0஺(3)(ឋ&;23⊤ᚖ=6ᔣḄᑡ(ឋ9ᑡ?ᨵ(ឋ஺(4)B&(ឋḄCDFᓽHIᐗ0I(ឋḄCDᡠ▲LḄF஺(5)ᐵNO&(ឋᡈ(ឋḄ0ᔠᐸDSTUᙢ᪗Xᐗ0஺ᙠVisualFoxPro_ᐵNO`᎛⌱ᐵNOcdU᪗eᐗ0Ḅfᵨ஺(6)᜜jᐵNO&᝞l⊤OmHno⊤Ḅ_ᐵNOᡈ᎛⌱ᐵNOpnq⊤Ḅ_ᐵNOᡈ᎛⌱ᐵNOrstOm((ឋ)c᜜jᐵNO஺2ᐵḄᱯv(1)ᐵwxyᓄ஺(2)ᙠIᐵHS{|I(ឋVisualFoxPro⊤}OmḄHI஺(3)ᐵHᐕᨵᐰIḄᐗ0ᓽᑍ஺(4)ᙠᐵᐗ0Ḅᐵ⌕஺(5)ᙠᐵᑡḄᐵ⌕஺5ᐵᐵᦪ8◤⌕ᑮᵨᡝᐶḄᦪtc◤⌕ᐵ8LḄᐵᐵḄoᨵ&Ḅᔠ`¡Ḅᐵ஺

3ᐰ¢£¤2¥VFPᜓὃ¨ᧇ2010—7-16Rebuilding᦮ᳮ1Ḅᔠ(1)¬&I#᪀ᐵḄ¬nᵫ(®tᐵḄᐰjᐗ00ᡂḄᔠ஺(2)°:I#᪀ᐵḄ°nᵫ(®²ᐵḄᐗ0pH(®³ᐵḄᐗ00ᡂḄᔠ஺´᝞ᐵR`SḄ°#lnᵫ(®RµH(®SḄᐗ00ᡂḄᔠ஺(3)¶:I#᪀ᐵḄ¶nᵫ(®tᐵᡠᐳᨵḄᐗ00ᡂḄᔠ஺’2¡Ḅᐵ(1)⌱¸&¹ᐵ{º»¼LᩩḄᐗ0Ḅ¾f஺(2)ᢗÀ&¹ᐵ!ᢣLÂÃ(ឋ0ᡂÄḄᐵ&(3)ÅÆ&ᐵḄÇᔣ#ᔠ;ᐵ!ÈÆᡂÉÊḄᐵ!஺(4)ËᯠÅÆ&ᙠÅÆᢥ᯿OmD"Ïᩩ8ḄÅƾfÏDÅÆ஺ËᯠÅÆnÐᣵÒÓ(ឋḄÏDÅÆ஺ÔÕ}&⌱¸`ᢗÀḄ¾fÖ×n⊤Ø®23⊤8ᑗᒘ஺ÅÆᑣ◤⌕Ü⊤f¾fÖ஺᝞l⊤ÝÞ8ÅÆ"Ø8ÅÆ஺1.3ᦪߣẠ6ᦪߣáâ1ߣãᑣ(1)ᐵᦪḄߣ"⍳¹ᭆæᓫᓄ“èᙢ”Ḅãᑣ஺(2)éêᙠ⊤ëì{|ÒÓOm஺(3)⊤ḄOmwxnãíᦪ`oᦪᐗî஺(4)ᵨ᜜jᐵNOïðᨵᐵὶḄ⊤ëìḄὶ஺2ߣáâᑭᵨVisualFoxProᩭôõᦪ"ᵨöÝᢥ᯿Ý÷áâᩭߣ஺(1)◤øᑖ᪆஺(2)ûL◤ø⊤C(3)ûL◤øOm஺(4)ûLὶ஺(5)ߣüû1.4VisualFoxProᭆ7VisualFoxProḄᱯvপþÿ⚗
ᦪᳮ஺(2)ᵨḄ᳛஺(3)ឋᢝInterneto(4)ᐙᑖᑭᵨᨵᦪ

4ᐰ!"#$%&VFPᜓὃ)ᧇ2010—7-16Rebuilding᦮ᳮ,%-./VFP0ஹVFP231ஹVFPḄ45VFP607〉ᔠ:;ᦪᳮḄᦪᳮ<=஺2ஹVFP>?=@:;ᦪᳮ⚞BḄᦪᳮ<=6dBASE,ᐸD⌕᱐GHdBASEII-*dBASEHl-dBASEIIIPlus—dBASEIV3ஹVFPḄ/ᓄJKFoxBase2.0/2.1-FoxPro2QfFoxPro2.5-*FoxPro2.6-*VisualFoxPro3.0--VisualFoxPro5.0-*VisualFoxPro6.0ᡃMNOḄ6VisualFoxPro6.004ஹVisualFoxProPᒹR3.0ஹ5.0ஹ6.0᱐GTḄUGᱯW:•Z[\ᓄ]^_`a☢஺•cᵨ☢ᔣefḄ_`ᢈh஺%ஹijVFP1ஹVFPḄklPᶍT2ஹVFPḄno3ஹVFPUGa☢Ḅ45•pᓫr•sᐹr•u᝱r•DwxHyz{|}஺•~ᵨHᐭ~Ḅᡠ஺07~ᢥVFP᡻Ḅ~஺~Ḅᐵyzᣩ0Ctrl+F4HᐵCtrl+F2Hyz஺4ஹVFPḄUG~•clearH◀DwxḄyz஺•?HᙠDwx?Ḅ0yzᐸ⌕yzḄᑁ஺•??HᙠDwx?ᑁ>yzᐸ⌕yzḄᑁ஺¡¢H£¤ᵨ¥Ḅ~[Z¦ᵨ஺5ஹVFPḄ⌨¨©᪗H«¬z஺H•ᣩ:Alt+F4o•⌨¨~HQUITo®ஹ¯°VFP

5ᐰ!"#$%&VFPᜓὃ)ᧇ2010—7-16Rebuilding᦮ᳮ1ஹ¯°VFP6ᢣeVFPḄs¶᛻/0¸¯°᝞º»Ḅ¼^½஺¾¸¯°[Z¿¥~/À[ᙠ“⌱⚗”eÄ᪾Æ/஺2ஹ“⌱⚗”eÄ᪾¯°VFPo1)u᝱rḄ¯°2)º»¼^¯°3)Ë4
Ì(s
Ì)¯°•ÎÏË4
Ì(s
Ì)?sys(5)+sys(2003)sys(5)0Ë4
ÌÆḄsys(2003)0Ë4
ÌÆḄÕÖ஺•¯°•×Ø(doformgzml.scx)4)¤¯°Ú»ᨵᦔÜஹNOVFP1ஹVFPḄÝÞ<=6ᡃMNOVFPḄ0GßàᦟâãäåæNM£ç¤ᵨ஺2ஹ¤ᵨÝÞ<=èé⌕êëÝÞ<=¾᪵éᑭíᡃM¿¥%&ὃî஺

6ᐰ!"#$%&VFPᜓὃ)ᧇ2010—7-16Rebuilding᦮ᳮ,®-VFPḄᦪï^ஹð;ñò#0ஹçó1ஹçó6⊤z07õö÷Ḅᦪ஺çóᨵᦪ÷;ஹøù;ஹúû;ஹüý;ஹº»;ஹº»þÿ6஺2ஹᦪ•ᦪ⊤ḄᐹḄᦪᦪᦪ஺•ᦪḄᑏ1!⊤᝞12ஹ+56ஹ-64.8*஺2+,⊤1.6E12⊤1.6X101201.6E-12⊤1.6X10-120-1.6E12⊤-1.6X10120-L6E-12⊤-1.6X10l2o3ஹ56•56ᵨᩭ⊤ᐹḄ56஺56Ḅ9ᦪ:ᦪ;ᵨ4:஺•56Ḅᑏ᝞$12,$12.68,-$12.68*஺4ஹ>?•>?ᵨᩭ⊤@ABḄ>?>?>?@஺•>?Ḅᑏ'abed'ஹ"abed"ஹIabedJᙳ⊤>?@abedo•LM1⊤>?NOḄ‘ஹ"ᡈR>?ḄBS?T⊤>?@ḄUVWXYZ>?@Ḅ[ᡂᑁ^஺>?@ḄNOBS?_`a᝞‘abed"*┯cḄ஺2d>?@eᒹgஹ"ᡈRh_`iᵨᐸTḄBS?᝞>?@abedk⊤"ab'ed"ᡈIab'edJ஺3>?ᦪleḄ>mᜧ9ᑏoᑖḄq᝞“abed"W"ABCD"ZwḄx>?@஺yzL{|}eḄ>mᜧ9ᑏZoᑖḄ᝞ClearஹcleArஹCLEAR*ᙳ⊤◀|}஺4xᓫ”ஹx""ஹeIJᙳ⊤ᨵ[ᡂᑁ^Ḅ>?@᪵Ḅ>?@@஺5[ᡂ>?@Ḅᑁ^ᨵ᝞"abcd"ஹ"abed'\""*AḄ>?@஺

7ᐰVFPᜓὃ¢ᧇ2010—7-16Rebuilding᦮ᳮ(6)¦§BS?k¨ᦻ?Zªeᦻ?஺yzL-{e¨ᦻ?«⚪:◀®>?@e¯§iᵨ?᜜ᐸT±ᔠᙳ³ªiᵨ¨ᦻ?´5ஹµ¶•µ¶ᵨᩭ⊤ABḄµ¶஺µ¶³ᨵ·WᎷx஺•µ¶Ḅᑏ·.T.ஹ.t.ஹ.Y.ஹ.y.0Ꮇ.F.ஹ.f.ஹ.N.ஹ.n.஺6ஹ!¹•!¹ᵨᩭ⊤ABḄ!¹஺•!¹Ḅᑏ2004º7ᨴ14!⊤"004-7-14
ஹ¼½2004.7.14
ஹA2004/7/14
,A2004714
o7ஹ!¹h¾!¹h¾ᵨᩭ⊤-ABḄ!¹Wh¾஺•!¹h¾Ḅᑏ¿¼½!¹h¾Àᐸe!¹Ḅᑏ¿w!¹h¾Ḅᑏ¿ᨵ8:10:30ஹ18:15:25ஹ8:10:30Aஹ8:10:30AMஹ8:10:30Pஹ8:10:30PM஺ÁᙠÃᡈÃÃ|}OᑏᔜÅஹÆ¿ḄÇÈḄ⊤ᔲA஺ᙠÃᡈÃÃ|}OÊËÌÍÎ⚗Ḅiᵨ⌹ÑÒᑖ◞஺ஹÔ1ஹÔ⊤ÔḄᦪl஺ÔᵨÕᩭ⊤ÖÕÔÕ஺ÔÕ×>mᡈØ>UVᐸO>mஹØ>ஹᦪ>ÙÚÛ?(᝞{ᑜÞ0ßὃa,aa,bl2,c_l,alB2,2d4,w,à“w,à”஺2ஹÔḄáâã|}äåa=12⊤Ôaã120store34.2toa,b,c⊤æ34.2ᑖçãèÔa,b,c»3ஹã|}Ḅ¿Ô=⊤ê¿store⊤ê¿toÔ1,Ô2,.......4ஹÔḄÅᵫᐸḄÅìB஺5ஹÔḄíiᵨÆ¿——ᦪ[•ïáÔÔkðᦪ[ÔᓾÔkò஺ᦪ[ÔeḄóᦪ[ᐗõ஺öᦪ[ÔḄ÷ÕwïáÔᦪ[ᐗõᵨᦪ[ÔÕø{᪗Ḅᩭ⊤᝞a(1)ஹa(2)ஹb(1,1)ஹb(1,2)*஺úLᦪ[ᵨ{᪗ᩭoᑖᐸ

8ᐰVFPᜓὃ¢ᧇ2010—7-16Rebuilding᦮ᳮ------T-Wᐔõ஺•᝞üᦪ[ᐸᐗõ³ᵨ{᪗ᑣÖᦪ[…ÿᦪ
᝞ᦪ
ᐸᐗᵨ᪗ᑣᦪ
ᦪ
஺•ᦪ
ḄᵨḄᵨᨵᡠ!"ᦪ
#$ᐜ&'ᯠ)*+ᵨ஺•&'ᦪ
"dimension/declareᦪ
-.᪗/▲1᪗/▲ᢣ᪗Ḅᨬᜧ5஺᪗▲ᢣ᪗Ḅᨬ675஺VFP8᪗Ḅ▲9&1,:;<$ᙠ&'ᦪ
>ᢣ&஺•&'ᦪ
"dimension/declareᦪ
-.?᪗/▲?᪗/▲1•ᦪ
&')᝞@AᐸB5ᑣᔜᐗᎷ5஺•Eᦪ
B5>;ᐸᐗᙳHᑮ5JKLᐸᐗᑖNBL!Ḅ5஺•ᦪ
OPQRSTᐸᐗKL஺6ஹVᨵᐵḄXᵨYZ,listmemoryYZ[\"p60o]+"^_`a஺bc"஺d8YZ[\Ḅdᑏf&"8ghiᑖ⊤_⌱⚗mghiᑖᑁo.pqiᑖ1⌕᪷t⌕uvwxᩨ.zᩨ1{ᑁo⊤_|+⌱}ᐸ஺஺^_Ḅ`a~ᨵᡃᵨḄᒹgVFPᡠᨵḄ.-ᙳLᑜ1஺O“like-ு⊤_|^_V-Ḅ`a஺-ᢣᒹᡈ*Ḅ-ᐸ8⊤_KLḄh*⊤_KL¡Ḅh஺¢᝞a?c⊤_᪵Ḅ-"?a,??¤ca*c⊤_᪵Ḅ-"?a,ᨬ)c,8¥ᑁo஺O"toprinter"⊤_¦`a!>〈ᡭᓺªᡭᓺ"tofileீᦻு⊤_¦`a!>®ᐭᑮᢣ&Ḅᦻ8஺஺°^_Ḅ`a±²³´>µ☢Ḅ`a·¸²³´஺OVFPYZ89&ᵨḄ¹ᦻᓫ»¼ᶇq஺ᵨ>.¼ᶇqKL|ᑏ²µ☢iᑖ¿ÀÁ⌕ᨵ4஺,displaymemoryYZ[\"p60o]+"^_`a஺bc"listmemoryYZḄÂÃNᙠÄ"°^_Ḅ`a±²³´>,YZ+Æᑮ³´•³´ᙢ^_஺

9ᐰÉÊTªËVFPᜓὃÎᧇ2010—7-16Rebuilding᦮ᳮ,clearmemoryYZ[\"clearmemory]+"Ò◀ᡠᨵ஺bc"ᡃÒ◀ᣵḄ஺,releaseYZ[\1"release1,2,.......]+"Ò◀ᢣ&Ḅ஺[\2"releaseall]+"Ò◀ᡠᨵ஺[\3"releasealllike-]+"Ò◀V-Ḅ஺[\4"releaseallexcept-]+"Ò◀V-Ḅ஺/ª"ÕÖ×ᦪ
ḄᵨÕÖᨵᐵYZ஺¤ஹ⊤Ø\1ஹ⊤Ø\Aᦪt.Xஹ1ÙÚSTḄ\Û஺STKLÜSTJKLÜÝᦪ஺ᦋSTḄßàJKLᙠ⊤Ø\8ᵨᙊgh஺bc"•ÊTª8⊤Ø\âḄᡠᨵqᙳãᑡdᑏ஺•ᓫXᡈ⊤Ø\ḄᱯæᓽèÄ⊤Ø\ᶖ஺2ஹᦪ5⊤Ø\•Aᦪ5ëஹìíëᦪtÙÚSTḄ\Ûᐸ5ᦪ5ëᡈìíë஺•TîST"**ᡈ*ïðST*"ïñST/"◀ST%"uôST+"RST-"÷ST஺3ஹq⊤Ø\•AqëᦪtÙÚSTḄ\Ûᐸøùqë஺•qST"+"¦µ)qúÙÚᔠã᝞abcJ+def,ᐸøqúabcdef஺-"¦µ)qúÙÚᔠ㿦µ☢qúüiḄý[þᑮᔠã)Ḅÿ
஺᝞abcᐸ
abcdef஺

Ḅᐜ஺4ஹ⊤

10ᐰ!"#VFPᜓὃ&ᧇ2010—7-16Rebuilding᦮ᳮ•+,ᦪ./0Ḅ12ᐸ3,45678஺,⊤3,:p64⊤3.3஺5ஹᐵ<⊤•=>ᐵ<
/0?@Ḅ1஺᝞?@ᡂB2CDEF2ᔲᑣᎷ஺•ᐵ<
:p65⊤3.4஺ᐵ<
Ḅᐜ2JKLM☢Ḅ
஺ὶ<
MPQR?@Ḅᦪ.⌕TUV3,WᦪE,XYZ[\,?@]஺♦ᐵ<⊤ḄZᐵ<
^Ḅᦪ.ᜧ`aᑗᐵ2VFPc2ᦪ.ᜧ`Ḅd8:1ᦪE,ஹ[\,ecᜧ`஺W2,ஹ,☠PḄஹᜧ஺3CD,FᜧLᎷ஺4
,ூᓫ
ᜧ`Ḅd8௃jklMachineW"ᘤ]no:
ᜧ`:pqWᦪ
ᑮ‘92]ீᜧᑏuீ`ᑏuvwᜧ`:xᵨwYz{no᣸ᜧ`2᝞2}஽'jklPinYinWz{]noV:
ᜧ`:pqWᦪ
‘0᎔'9'<'a'<'A'<'b'v'B'........vwᜧ`:Yz{no᣸ᜧ`2᝞2}‘W'jklStrokeW]no:
ᜧ`:pqWᦪ
ᑮ'9D<,a,<,A,<,b,<,B,……vwᜧ`:Yᑏ8ᜧ`2Ḅᜧ஺ூnoḄkl௃V:“⌱⚗”+᪾ckl஺#:ᵨkl:setcollateto"Machine”setcollateto"PinYin”setcollateto"Stroke”ூ
,ᦪ.Ḅᜧ`௃
ᜧ`Ḅᑨ8dᑣ:2⌲
/0?@2ᑮ
ᑖᜧ`¡…£M
,ᦪ.ᜧ`dᑣ¤¥]¦§?@W¨©]:
Ḅ?@Y^
Ḅª7ª஺«τW?@¤¥]§?@:

11ᐰ!"#VFPᜓὃ&ᧇ2010—7-16Rebuilding᦮ᳮ
Ḅ?@Yᨬ
Ḅª7ª஺ᚪ(?@¤¥)ூ?@Ḅkl௃V:“⌱⚗”+᪾c/0஺#:SETEXACTON&&kl§?@SETEXACTOFF&&kl¦§?@ூ²ὃஹ³´Rµ¶௃1)·¥jM?@஺µ¶:ffiilSET('EXACT')¸ᦪ¹X·¥஺2)ᑖºᙠ¦§?@Z§?@¼ᑨ½¼¾ᐵ<⊤ḄE:XYZ¿XYீXY±XYZ22'XYZ==XY,,XY=='XYZ',‘XY'<'XYZ','XYZ'>'XY'஺6ஹCD⊤•+CD,ᦪ./0Ḅ12CD,஺•CD
:.not.ᡈnotᡈÁ:¦v.and.ᡈand:Rv.or.ᡈor:ᡈ஺ᐜ(Â~K):¦ஹRஹᡈ஺JÄÅḄᐜᙳKLM☢Ḅ
஺ÇÈ:᝞V
É+Vᦪ./02ÊËᓫÌ
v᝞+ᦪ./02ÊÍÌ
஺7ஹCD⊤ஹᐵ<⊤ḄÎÏVFPc2ÐᵨCD⊤ஹᐵ<⊤⊤¶ᩩÒ஺jCD⊤ஹᐵ<⊤ḄEF2ᡠ⊤¶ḄᩩÒᡂBvjCD⊤ஹᐵ<⊤ḄEᎷ2ᡠ⊤¶ḄᩩÒÔᡂB஺Õ:Öᵨᐵ<⊤ᡈCD⊤⊤¶᝞¼ᩩÒ2×ØÙᩩÒḄᡂBRᔲZ⊤FᎷEËḄᐵ<஺1)AᜧL52)AÔᜧL53)AᜧL5ÚB`L104)AᜧL5ᡈB`L105)Aᙠ5Z20ËÛ":p63Õ3.8vÜ⊤3.3cḄÝV⊤3,ÞVßÕ2×àáᐸvp68Õ3.15vâஹxᵨ¸ᦪ1ஹ¸ᦪU/0ᦪ.ḄãV⌶å஺2ஹ¸ᦪḄVæÐᵨq:

12ᐰ!"#VFPᜓὃ&ᧇ2010—7-16Rebuilding᦮ᳮ¸ᦪç(èé2èé2……)èéêÊQᦪ஺ëèé2ᙊíî¹⌕ᑏÛ2᝞DATE()ï஺3ஹxᵨ¸ᦪ(1)ᦪEᜐᳮ¸ᦪ•ABS¸ᦪñ:TVᦪḄò+E஺Õ:ABS(67),ABS(-67+89),ABS(-82)•SIGN¸ᦪñ:jèéEó2ôõ1vjèéEöV2ôõ-1vjèéE02ôõ0஺Õ:jèéAḄEó2B÷YE8+20vjèéAḄEö2B÷YE8-20vjèéAḄE02B÷YE8஺•SQRT¸ᦪñ:TóᦪḄø᪷஺Õ:SQRT(2)ÇÈ:¨©!2ú`ᦪ஺SETDECIMALSTOXklḄ`ᦪúᦪ஺•PI¸ᦪñ:ûᑮLIḄE஺Õ:PI()•INT¸ᦪñ:ôõèéḄ᦮ᦪᑖ஺Õ:INT(1.3),INT(1.6),INT(-1.3),INT(-1.6)•CEILING¸ᦪñ:ôõᜧLᡈïLèéḄᨬ`᦮ᦪ஺Õ:CEILING(1.3),CEILING(2),CEILING(-1.3),CEILING(-2)•FLOOR¸ᦪñ:ôõ`LᡈïLèéḄᨬᜧ᦮ᦪ஺Õ:FLOOR(1.3),FLOOR(2),FLOOR(-1.3),FLOOR(-2)•ROUND¸ᦪñ:+èéḄE/0âýþᐭ
஺
⊤ᑮ஺ROUND(345.345,2),ROUND(345.345,1),ROUND(345.345,0),ROUND(345,345,-1)•MODᦪ᦮ᦪ◀Ḅ!ᦪ஺MOD(10,3),MOD(9,3),MOD(11,3)"#ᨵ%ᦪḄ!&ὃ⇋஺•MAXᦪ

13ᐰ+,
-.VFPᜓὃ0ᧇ2010—7-16Rebuilding᦮ᳮ345ᢧ7ᨬᜧḄ:஺MAX1,2,7,4,5,MAX'A','ABC','BC'"#Ḅ;<=>஺•MINᦪ345ᢧ7ᨬ?Ḅ:஺MIN1,2,7,4,5,MINA‘'ABC','BC'"#Ḅ;<=…>஺2ABᜐᳮᦪ•LENᦪABDḄEF஺"#GAEFH2,IᦻABKᒹMNOPEFH1஺LENK"ᚡVisualFoxProSTU”P•LOWERᦪW5ḄᡠᨵAYZᓄH?ᑏAY஺LOWERKᓃ.VisualFoxProSTU”P•UPPERᦪW5ḄᡠᨵAYZᓄHᜧᑏAY஺UPPER“
VisualFoxProSTU”P•SPACEᦪ^_ᢣaᦪNObᡂḄABD஺SPACE10•REPLICATEᦪᵫᢣaABDefbᔠ^_ABD஺REPLICATE'*'h0,REPLICATEiABCD,,5•TRIMᦪWAB

14ᐰ+,
-.VFPᜓὃ0ᧇ2010—7-16Rebuilding᦮ᳮ•SUBSTRᦪ3ABD5stD஺:SUBSTR(“uᓤzw”3,2),SUBSTR(“uᓤzw”3,4)•OCCURSᦪABDᙠABD57Ḅᦪ஺OCCURS("ab","huabhgtabagfbyrba"),OCCURS("ab","huahgtbagfbyrba")•ATᦪABDᙠABD57Ḅ஺AT("ab","huABygabhgtabagf"),AT("ab","huABygabhgtabagf",2)•ATCᦪABDᙠABD57Ḅ&ᑖAYᜧ?ᑏ஺ATC("ab","huABygabhgtabagf"),ATC("ab","huABygabhgtabagf",2)•STUFFᦪᵨABDᣚABD5Ḅᑁ஺STUFF("gtyabku",3,4,"AA")ὃ1)ᙠ"ab"Ḅaஹbᐭ""஺2)W"ᓅ᯼▾”5Ḅ“᯼”Aᑤ◀஺•CHRTRANᦪABD5ḄABᣚ஺1CHRTRAN("ABACAD","ACD","X12")2CHRTRAN("ᜧz""ᜧ")•LIKEᦪABD5ḄABABD5ABᔲ=¢£¤¥,ᔲᑣ£¤Ꮇ஺1LIKE("ABA","ABAD")"#ABD5©ªᵨ«¬B஺2LIKE("AB*","ABAD")(3)®ஹᦪ•DATEᦪ£¤¯°±²®஺DATE஺•TIMEᦪ£¤¯°±²஺T1ME()"#ᦪ:HAB<஺•DATETIMEᦪ£¤¯°±²®³஺DATETIME0

15ᐰ+,
-.VFPᜓὃ0ᧇ2010—7-16Rebuilding᦮ᳮ•YEARᦪஹMONTHᦪஹDAYᦪᑖ´£¤®ᡈ®<=Ḅ¶·ஹᨴ·t஺YEAR(DATE()),MONTH(DATE()),DAY(DATE())•HOURᦪஹMINUTEᦪஹSECᦪᑖ´£¤®<=Ḅஹᑖஹ¹஺HOUR(DATETIMEO),MINUTE(DATETIME()),SEC(DATETIME())ὃ10?º»¼(4)Zᣚ;ᦪ•STRᦪWᦪ:ᔲᑣWZᓄHN®஺•CTOTᦪW®ÎÏḄABDZᓄH®<஺CTOT("2004/7/1610:10")

16ᐰ+,
-.VFPᜓὃ0ᧇ2010—7-16Rebuilding᦮ᳮ(5)ÔÕ;ᦪ•BETWEENᦪᑨ×ᦪØᔲᙠÙᦪØH¥ᔲᑣHᎷ஺BETWEEN(2,1,16),BETWEEN("2","1","16")•EMPTYᦪᑨ×ᦪØᔲN:(p76⊤3.7),H¥ᔲᑣHᎷ஺EMPTY(0),EMPTY("0"),EMPTYEMPTY(""),EMPTY({))•VARTYPEᦪᑨ×ᦪØḄ;<஺VARTYPE(A)4ஹᐺ<ᦪÛÜ•ᩩßᦪᵨàIIF(áâ<⊤ãÏ⊤ãÏ1,⊤ãÏ2)᝞åáâ<⊤ãÏḄ:H¥ᑣ⊤ãÏ1Ḅ:æHᦪ:ᔲᑣ⊤ãÏ2Ḅ:æHᦪ:஺ᦪnF(X>10,‘AAA','BBB')ὃ¯Xᑖ´s:10ஹ0ஹ100ᦪIIF(X>10,'AAA',nF(X<10,'BBB','CCC'))Ḅ:஺•çᣚᦪᵨà&AB<.ᵨAB<Ḅ:(&¿aêB)ᣚ᦮çᣚᦪ஺ᎷëA='76+28',ì⊤ãÏ1+A1+&A.ᑖ´íîïðñ¼"#(1)òᦪᓝᑖᨵᵨôᓝᑖᱯöḄᦪ஺(2)çᣚᦪ7ᙠABD5÷øᨵᦔúᐸüᦪ7ᙠABD5ý¯æABᜐᳮ஺ᓽÿA='ABC',ᑣX&A.YXABCYABS(-86)'ᓾ'86'஺(3)ᣚᦪᨬḄᦪᣚᦪḄ᪗஺ᣚᦪᐸḄᑁ!"#ᑖ%&'(᪗)*ḕᶍ஺-ὃ/0☢Ḅ⊤34567ᣚᦪḄ᪗)*ḕᶍ8Ꮇ:A='76+28'஺&A.+52,&A.6-285,'&A.BCDEFG'஺;;

17ᐰFGH¿Ì᪾ᩭ⌱ÐᦪSTḄÑÒUÓÔᦪST_஺2ÅÆ5ᢣÊ⌕stḄᦪST')*ḕᶍᦪST᡽^_஺᝞Ö⌕stḄᦪ

18ᐰFGH¿Ì᪾ᩭ⌱Ð⊤ḄÑÒUÓÔ⊤_஺2ÅÆ5ᢣÊ⌕stḄ⊤')*ḕᶍ⊤᡽^_஺᝞Ö⌕stḄ⊤ᦻb×ØᙠÙZÚᑣᦻb_Û☢mÜÝÓÔᦻbÑÒ஺᝞ÖᦻbÑÒᡈᦻb_5ᵨᑮßᑣᡠÓÔḄᑁÛàá;âÊãâ஺3X\⊤Ḅᡂí`⊤Ḅ᪀஺4᝞ᨵᦪᡭ᝱ᑣḄ⊤ᦪ஺5⊤ᜐᙠᡭ᝱!ᑮ⊤ᑁ$஺6%&'()ᡭ%⊤ᐵ+,-ᡭḄ⊤஺ᓽ%&'()/0ᡭ%⊤஺ᡠᡭḄ⊤2᝱34567ᐵ89஺2᝱3ᡠᑮḄ⊤:;⊤஺3ஹᐵ+⊤=ᦪᐵ+⊤•?@ABUSEᐵ+ᦪ,?@ABCLOSEDATABASES&&ᐵ+ᦪCLOSEDATABASESALL&&ᐵ+ᡠᨵᦪ4ஹᡭᦪ•EᓫAB,?@ABOPENDATABASEGᦪHIJKᵨ“OPENDATABASE”ᡭᦪMN!OPᦪQR⌕

19ᐰVWXYZ[VFPᜓὃ^ᧇ2010—7-16Rebuilding᦮ᳮbOPcd᡻f“MODIFYDATABASE”?@஺5ஹᡭ⊤•EᓫAB•?@ABUSE⊤[EXCLUS1VE/SHAREDJIJK1)⌱EXCLUSIVE⌱⚗M⊤5ᓰAᡭ⌱SHARED⌱⚗M⊤5ᐳAᡭ஺ḕᶍM;5ᓰAᡭ஺ᓰAᡭM⊤Ḅ᪀45ᦋ⊤Ḅ45ᑤ◀஺2)%&'()ᡭ%⊤MᡭḄ⊤ᐵ+஺6ஹᦋ⊤᪀•EᓫABK“OPI⊤Wᘤ”•?@ABKMODIFYSTRUCTUREIJKᦋ%⊤᪀7⊤cᡭ஺YKP113Y⚪1জঝ஺¦ஹ⊤Ḅᨵᐵ§¨ᱯª«PK¬⊤f®¯§¨°⊤±⌕⚜ᐜᡭ஺1ஹ⊤QR´ᐸ§¨•⊤QRḄᡭEᓫAK“OPI¶Z?@AK?@1KBROWSELLAST]?@¹ḄLAST⌱⚗º⊤QR5»ḄOP᜜½6¾஺?@2KEDIT?@3KCHANGE?@4KAPPEND•IJK(1)⊤QRᨵÃÄOPAKÅÆA=ÇÈA஺(2)⊤QRᨵÃÄɨAKÊËA=ÌÊËA஺ºᵨAPPEND?@ᡭḄ⊤QRᜐᙠÊËAᐸÍᙳᜐᙠÌÊËA஺᝞ᜐᙠÌÊËɨA45ᐸÏᣚ;ÊËAÑ!f஺(3)⊤QR6¾45¬⊤Ḅᑁ$f®ÒḄᦋ஺ᯠ᝞⊤5/ÔAᡭMᑣἭÖᦋ஺?@Aᡭ⊤PË“NOUPDATE”⌱⚗⊤P5/ÔAᡭ஺(4)⊤QR6¾VFP6%“⊤”Eᓫ2¹ᡃØ45fÙ§¨஺2ஹÚÛᢣ┐

20ᐰVWXYZ[VFPᜓὃ^ᧇ2010—7-16Rebuilding᦮ᳮ•ᢣ┐ḄÞ(1)⊤¹ᨵÙ;ßᢣP64§¨ḄVFP;ᡭḄ⊤à᣸%“ᢣ┐”஺ᢣ┐ᡠ“ᢣ”Ḅ:;஺(2)%⊤âᡭMᢣ┐ᢣᔣ1ä஺åḼ§¨Ḅfᢣ┐ᦋçᐸᢣᔣ஺ᡃØè45é;êᢣ┐஺(3)ᢣ┐ḄÛë452᝱36஺è4ìíRECNO()îᦪïðñ஺•ᢣ┐ḄÚÛGOTOPᡈGOTOTOPᢣ┐ᢣᔣ⊤¹ᨬ☢Ḅ஺IJKᙠᢣ┐,-ᢣᔣᨬ☢Ḅ'()᝞õᢣ┐dê“%ö”,ᑣ:“ᢣᔣß⊤Ḅᜮ”øMîᦪBOF()Ḅï;ù஺ᙠᢣ┐,-ᢣᔣ⊤ᜮḄ'()d“úûü%ö”ý6┯஺GOBOTTOMᡈGOTOBOTTOMᢣ┐ᢣᔣ⊤¹ᨬ☢Ḅ஺IJKᙠᢣ┐,-ᢣᔣᨬ☢Ḅ'()᝞õᢣ┐dê“%ö”,ᑣ:“ᢣᔣß⊤Ḅÿ”ᦪEOF()Ḅ஺ᙠᢣ┐ᢣᔣ⊤Ḅ“”┯஺GO"#$ᡈGOTO"#$ᡈ"#$"#ᢣ┐ᢣᔣᢣ'"#$Ḅ"#஺()*VFP+,-⊤.Ḅ"#/01$2ᡃ4ᡠ(Ḅ"#$஺"#$6178"#$Ḅ9:;᧜="#ᙠ⊤.Ḅ>▭9:஺SKIP"#ᢣ┐@AB"#஺SKIPn(nC᦮ᦪ)"#ᢣ┐@AnB"#஺SKIP-n(nC᦮ᦪ)"#ᢣ┐FAnB"#஺•Hὃ*"#ᢣ┐ᢣᔣ⊤ᜮKLMF"#$N"#ᢣ┐ᢣᔣ⊤KLMF"#$஺ᡠOPḄ"#$QRSḄTUᔩWRTXᳮZᔩW3ஹᙠ\]^OP"#•LISTOP⊤.ᐰ`"#஺OPab"#ᢣ┐ᢣᔣ⊤஺•LISTdOPᢣ'dᑁḄ"#஺d*ALL—ᐰ`"#NEXTnMF"#78ḄnB"#RESTMF"#ᑮᨬ@B"#RECORDn—hn$"#஺•LISTFORᩩjOP⊤.kᔠᩩjḄ"#஺•LISTFORᩩjdᡈLISTdFORᩩjmOPᢣ'dᑁkᔠᩩjḄ"#஺

21ᐰnopqrsVFPᜓὃuᧇ2010—7-16Rebuilding᦮ᳮ•DISPLAYOPMF"#஺•DISPLAYdULISTd஺•DISPLAYFORᩩjULISTFORᩩj஺•DISPLAYFORᩩjdᡈDISPLAYdFORᩩjULISTdFORᩩj஺•()*(1)LISTxyzDISPLAYxy◀=h|ᵨ~Xᨵ᜜᜜B2*MOPḄ"#LISTxyTX]]OP"#DISPLAYxy஺(2)xy.OFF⌱⚗ᑣTOP"#$஺(3)ᢣ'OP*FIELDS1,2,……o(4)᝞"#〈ᡭᓺqTOPRINTER⌱⚗஺(5)VFPxy.UB⌱⚗4¡¢9:஺(6)ᶇ¢OPF@"#ᢣ┐¤¥Ḅ¦ᓄ஺4ஹᔣ⊤.¨"#•INSERTMF"#©@ªᐭ¬"#Uᡭ7⊤®¯°ᑏᑁ²஺•INSERTBLANKMF"#©@ªᐭ¬"#³Tᡭ7⊤®஺•INSERTBEFOREMF"#©Fªᐭ¬"#Uᡭ7⊤®¯°ᑏᑁ²஺•INSERTBEFOREBLANKMF"#©Fªᐭ¬"#³Tᡭ7⊤®஺•APPENDᙠ⊤Ḅᨬ@¨¬"#Uᡭ7⊤®¯¬"#°ᑏᑁ²஺•APPENDBLANKᙠ⊤Ḅᨬ@¨¬"#³Tᡭ7⊤®஺•APPENDFROM⊤FORᩩj´ᢣ'⊤."#ᨵᩩjᡈµᩩjᙢ·ᑮMF⊤@஺xy.ᢣ'Ḅ⊤µ¸ᡭ7஺¹*ᐜᑖKL“¼½Ldbf”z“¼½.dbf”Ḅᑁ²ᯠ@“¼½l.dbf”.¿ÀÁÂ20Ḅ"#·ᑮ“¼½.dbf”.ÃKL·@Ḅ“¼½.dbf”ᑁ²஺5ஹ+,Äᣚᑁ²xy*REPLACE1WITH⊤Æ1,2WITH⊤Æ2,.......Çd´FORᩩj´

22ᐰnopqrsVFPᜓὃuᧇ2010—7-16Rebuilding᦮ᳮX*-⊤.ᢣ'dᑁkᔠᩩjḄ"#/0Äᣚ஺ḕᶍdzᩩjÊ-MF"#/0Äᣚ஺¹*-¼½⊤/0᝞Äᣚ*•ËÌᝄ¼Î1000ᐗ஺•᪷ѽÒÓÔÕop¿ÀCEILING•85¿FÖᒹØ85¿Ù½Ḅ¼½ᝄ¼ÎÚ100ᐗ஺•ᵱ½ᝄ¼Î100,᝕½ᝄ¼Î150o6ஹ"#Ḅᑤ◀•Þßᑤ◀Öᓽᙠ"#áBᑤ◀᪗"ÃT2Ḅᑤ◀Ùxy*DELETEÇd´FORᩩj´X*ᑤ◀ᢣ'dᑁkᔠᩩjḄ"#஺ḕᶍdzᩩjÊᑤ◀MF"#஺()*᝞MF"#ãÞßᑤ◀ᑣᦪDELETEDÖÙ஺•Þßᑤ◀"#ḄឮåÖᓽæçᑤ◀᪗"Ùxy*RECALLÇd´FORᩩj´X*ឮåᢣ'dᑁkᔠᩩjḄ"#᝞ãÞßᑤ◀Ḅè஺ḕᶍdzᩩjÊឮåMF"#஺()*éᙠ⊤®.êëì᪗ᡈCtrl+TíÞßᑤ◀/ឮå"#஺ᱥᳮᑤ◀ÖḄ"#6⊤.ᑤ◀Ùxy1*PACKX*ᱥᳮᑤ◀Þßᑤ◀Ḅ"#஺xy2*ZAPX*ᱥᳮᑤ◀⊤Ḅᐰ`"#Tðᐸ2T2Þßᑤ◀஺7ஹKò"#xy*LOCATEFORᩩjÇd´X*6⊤.òkᔠᩩjḄhB"#஺()*1òᑮ᪵Ḅ"#@Ê2"#ᢣ┐ᢣᔣᡠòᑮḄ"#ÃTOPᡠò"#Ḅᑁ²஺Ö2⌕Kò⊤.kᔠᩩjḄB"#õᵨContinuexy஺Ö3òᑮ"#ᦪFOUNDᔲᑣᎷ஺Hὃ*òTᑮkᔠᩩjḄ"#"#ᢣ┐ᢣᔣøᜐW8ஹúû⊤."#Bᦪ6ü᝱þLéêëRECCOUNTÖÙᦪúû஺q*ÿ
ᑁ஺ஹ1ஹḄ•ᙠᦋ⊤ḄᑮḄ஺

23ᐰ#$%&'(VFPᜓὃ+ᧇ2010—7-16Rebuilding᦮ᳮᎷ012⊤:1456782003001=>212003002?202003003@A192003004=>182003005FG20᝞IᡃKLMᑮ
“56”ᓣ᣸ᑡḄSTUVWXYZ
“56”ᓣ᣸ᑡḄ᝞“⊤”V564?2@A3=>1=>4FG5[\“⊤”S]^
_`“56”ᓣ᣸ᑡḄ஺\“⊤”]abc12⊤ḄYZ஺YZ⊤Sᐸ^
ᨵfZ஺•Ḅᨵᐵᭆij1k6VWXḄᡠmḄ6n஺j2k⚗jᐵpnᡈ⊤rskVWXḄtuS᝞vḄ“56”nw஺⚗^
YZnwSx^
YZ⊤rs஺᝞LMWXYZy᪵ḄV
“56”ᓣ᣸ᑡS{Ḅ“56”|}~S
“78”Ḅᓣ᣸ᑡ஺y~S⚗]V56+78᝞V56+strj748,2k?202193=>184=>211FG205•Ḅj1kV᝞I}Sᐸ⚗⌕}SᑣSy᪵Ḅ^
஺j2k᎛⌱V᝞I}Sᐸ⚗⌕}SᑣSy᪵Ḅx^
᎛⌱஺᎛⌱ḄVYZ⊤SᨵYZS^
ᨵfZ᎛⌱஺

24ᐰ#$%&'(VFPᜓὃ+ᧇ2010—7-16Rebuilding᦮ᳮ3V⚗▲ᑴ⌕Ḅ^I஺4YV⚗|}ḄSᙠ■■Z஺ᨵy¡⌕Ḅ¢Y஺[¤jY¥¦k•Ḅ§¨j1k©⊤Yª§¨ᙠ⊤ᦻ¬Sᓫ¯§¨ᑮᦻ¬஺j2ᦻ¬ḄVᓫᦻ¬VYZᦻ¬¨§YZ஺ᓫᦻ¬Ḅ᡽±6IDX஺²ᔠᦻ¬VYZᦻ¬¨§fZS}
6´µᑖ஺²ᔠᦻ¬Ḅ᡽±6CDX஺᝞I⊤Ḅ·Z²ᔠᦻ¬Sᐸ¸¹6⊤}6Sᑣ\²ᔠᦻ¬º»᪀ᓄ²ᔠᦻ¬Sᔲᑣº¿»᪀ᓄ²ᔠᦻ¬஺j3ÀᯠSYZ⊤Ḅᓫᦻ¬^
ᨵfZS¿»᪀ᓄ²ᔠᦻ¬x^
ᨵfZS»᪀ᓄ²ᔠᦻ¬ᨵYZ஺Ã▭ÅᵨS
»᪀ᓄ²ᔠᦻ¬ᨬÈᵨ஺•ḄᐸÉj1k}ᦪuË©⊤Y᪵Sxᨵ{ᐸᡭÍÎ᝱~SÐÅᵨ஺WYZ~SᐸÑÒᜐᡭÍÎ᝱Ô»᪀ᓄ²ᔠᦻ¬ḄSÕ⊤ḄᡭÍÑÒᡭÍÔᓫᦻ¬Ö¿»᪀ᓄ²ᔠᦻ¬Ḅ×ØÙᡭÍ஺j2{fZÚᡭÍ~S^
ᢣ·Z{Ü஺{Üx^
Ýᨵ஺᝞IÝᨵ{ÜSᑣ⊤´µᜐᳮ~S
⊤Ḅ´µjvLISTஹGOTOPÞkÔ᝞Iᨵ{ÜSᑣ⊤´µᜐᳮ~YS
{ÜḄ´µjvLISTஹGOTOPÞk஺3{ᜐᙠᡭÍÎ᝱~SḄᑁßÕ⊤ᑁḄᦋÑÒà᦮஺x]áS{YZᜐᙠᐵâÎ᝱~S⊤ᑁᦋãSᑁᑮÖ~à᦮,y]äåᑁḄ“ὁᓄ”஺çS^
ᡭÍSᐸ´µèᓽ^஺^êS⊤ḄYëì⌕íᐸᜐᙠᡭÍÎ᝱஺2ஹḄᨵᐵîb•ḄWXj1k»᪀ᓄ²ᔠᦻ¬ḄWXᙠ“⊤0$ᘤ”WXVêðñ஺òóôsWXVINDEXONI⚗TAGI6[ASCENDING/DESCENDING]rUNIQUE/CANDIDATE]áõVUNIQUEYWYSCANDIDATEYW᎛⌱Sᢣ஺j2ᓫᦻ¬ḄWXINDEXON|⚗TOᓫ|ᦻ¬[ASCENDING/DESCENDING]rUNIQUE/CANDIDATE]j3¿»᪀ᓄ²ᔠᦻ¬ḄWX

25ᐰ#$%&'(VFPᜓὃ+ᧇ2010—7-16Rebuilding᦮ᳮINDEXON⚗TAG6OF¿»᪀ᓄ²ᔠᦻ¬[ASCENDING/DESCENDING][UNIQUE/CANDIDATE]áõVWḄÑÒᜐᡭÍÎ᝱S÷ᵨòóôsWXḄ{Üj“⊤0$ᘤ”WXḄÚÑÒ0{Ük஺•ḄᡭÍj1k»᪀ᓄ²ᔠᦻ¬ḄᡭÍÕ⊤ḄᡭÍᡭÍ஺ᡭÍãSÝᨵᢣ{Ü஺j2ᓫᦻ¬ஹ¿»᪀ᓄ²ᔠᦻ¬ḄᡭÍK©⊤YªᡭÍUUSE⊤INDEXᦻ¬1,ᦻ¬2,……K⊤ᡭÍãᡭÍøSETINDEXTOᦻ¬1,ᦻ¬2,.......[ADDITIVE]áõVYZᡈYᢇᦻ¬ᡭÍãSúÜᡭÍḄᦻ¬jᒹü»᪀ᓄ²ᔠᦻ¬kýÑÒᐵâS◀¿òóᨵ“ADDITIVE”⌱⚗஺•0ÿ
SETORDERTO[ASCENDING/DESCENDINGJ1ᓫᦻஹ᪀ᓄᔠᦻஹ᪀ᓄᔠᦻ஺SETORDERTO[TAG][ASCENDING/DESCENDING]ᓫᦻḄ"ᓫᦻḄ#$஺%&1᝞()*+,-.ᙠ0ᢣ&ᐸᡠᙠḄᔠᦻOFᔠᦻ஺2
456+7ᢣ8ᓣஹ:;+7ᢣ8"<=>Ḅᓣஹ:஺3SETORDERTOᡈSETORDERTO0⊤A;ᢣ8
஺4456ᙠᡭ>ᢣ8
஺C>ᙠᡭDEFG᝞H⌱⚗ᓽ5ORDER[ASCENDING/DESCENDING]ORDER[TAG][ASCENDING/DESCENDING]5⊤LM)*0⌱N“⊤/Qឋ”TᓫUVVWXY
ᡭḄஹḄ456Z[
஺6ORDER஺\ᦪ56XY
Ḅ஺^
>_"`a஺•+7DEREINDEXUVcᡠᨵᡭḄef+7஺%&⊤LM)*0456gh“⊤”Tᓫef+7஺•᪷j⚗klmnopSEEK⚗qUV᪷j
l)ᢣ8⚗qḄr_smntmnᢣ┐ᢣᔣwm

26ᐰyz{|}~VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮn஺᝞lᑮmnᢣ┐ᢣᔣ⊤஺%&1”⚗q”ᜐ56_s⊤p஺2lᑮ0\ᦪFOUNDq"ᔲᑣ"Ꮇ஺3⌕lᑮ⚗qḄH_smnᵨSKIPDEᓽ5;VᵨCONTINUEDE஺4᝞(ᙠ
᪷jᐸ⚗efklᑣDE.ᢣ8_sORDER[ASCENDING/DESCENDING]ORDER[TAGJ[ASCENDING/DESCENDING]•ḄᐵCLOSEINDEXESᡈSETINDEXTOᐵ◀᪀ᓄᔠᦻ6᜜Ḅᦻ஺᜜⊤ᐵ0ᐸᙳᐵ஺•Ḅᑤ◀1᪀ᓄᔠᦻḄᑤ◀ᙠ“⊤Zzᘤ”ᑤ◀A஺DELETETAG1,2,.......DELETETAGALL2᪀ᓄᔠᦻḄᑤ◀DELETETAG1OF᪀ᓄᔠᦻ2OF᪀ᓄᔠᦻ……DELETETAGALLOF᪀ᓄᔠᦻ3ᓫᦻḄᑤ◀ᙠᦻᜳLMᑤ◀ᓫᦻᓽ5஺G|ᑁ£•<=_s“¤¥¦ᳮᦪj§”ᐸᒹ©ª«⊤ªC7,¬C6,®Iஹ¤¥⊤¥C5,¥C10,)᱐°C12±²▅⊤ªC7,¥C5,²▅´µD,¶"·⊤¸ᐭ_ºmn஺•tª«⊤["
⊤ᙠ“⊤Zzᘤ”6“ª”"ᐵ»¼<=_ᓣஹ:½86H4C᪵¿6''¬""ᐵ»¼<=_Âg¿6“¬+STR®3”"ᐵ»¼<=_ÂgÃI஺•t¤¥⊤["
⊤ᙠ“⊤Zzᘤ”6“¥”"ᐵ»¼<=_¿6''¥”"ᐵ»¼<=_Âg஺•t²▅⊤["
⊤6DEÄpᑖÆ6“ª”ஹ“¥”"ᐵ»¼<=Âg஺⌕ÇÈᑮ᪀ᓄᦻ஺

27ᐰyz{|}~VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ•cª«⊤ᑖÆZ[;Ḅ
(ᒹÊËᨵ
Ḅ,-)ᵨLISTDEÍAmnÎÎmnᙠ;HḄ,-஺•c¤¥⊤tZ"
ᯠ0ᑖÆᵨSEEKDEl)Ð_¥Ḅ¥±Ð_¥Ḅ¥஺•c²▅⊤Z[_
ᯠ0ÑÒHᑡDE᡻f0mnᢣ┐ḄÕᓄ(ÑÒÕᓄ
ᨬ×½ØᐜᑨÛ_Hmnᢣ┐ḄÕᓄᯠ0ÜÝ)(1)GO1(2)GOTOP(3)GOBOTTOM(4)SKIP•Þßᐸàᨵᐵᑁ£஺áஹᦪjâ᦮ឋ1ஹᦪjâ᦮ឋᓽᦪjãäឋ஺VFPᦪjâ᦮ឋ_åᒹÊæçâ᦮ឋஹèâ᦮ឋ±é᯿â᦮ឋëì஺2ஹæçâ᦮ឋḄí᪗ïæ*|ᑴ•æçâ᦮ឋḄí᪗ñò⊤;ó)*Ḅôsmn஺•æçâ᦮ឋḄæ*|ᑴgh"⊤<=ᡈ᎛⌱ᩭæ*஺3ஹèâ᦮ឋḄí᪗ïæ*|ᑴ•èâ᦮ឋḄí᪗ñòк¼÷Ḅøqᙠù8Ḅû஺•èâ᦮ឋḄæ*|ᑴ"¼÷Z8“¼÷ᨵᦔឋùᑣ”஺•ýþ஺4ஹé᯿â᦮ឋḄí᪗ïæ*|ᑴ•é᯿â᦮ឋḄí᪗ñòôs⊤ÿᦪḄឋ஺•᯿᦮ឋḄ(1)ᙠᦪ⊤Ḅᐵὶᐵ!⊤Ḅᐵὶᐵ!"ᢣ$ᙠ⊤%&'()*+,-⍝/⊤%Ḅ0ᐵ()஺᝞23⊤45▅⊤7“29”ᐵὶᐵ!;$23⊤%&'29<“2003002”Ḅ();ᑣ5▅⊤%ᡠᨵ29<“2003002”Ḅ()ᙳ<0ᐵ()஺⊤⌕Bᐵὶᐵ!CDE7“ᐵὶF”

28ᐰopqrstVFPᜓὃwᧇ2010—7-16Rebuilding᦮ᳮyzmᑣᢣ᱄⊤%(){ᦋ*}᝞~ᜐᳮ஺tὶyz\⊤%ᡠᨵ0ᐵ()▲ᑴ\⊤%ᨵ0ᐵ()ᑣἭ᱄⊤{ᦋᶍ᱄⊤X7{ᦋ஺ᑤ◀mᑣᢣ᱄⊤%()ᑤ◀*}᝞~ᜐᳮ஺tὶᑤ◀\⊤%ᡠᨵ0ᐵ()▲ᑴ\⊤%ᨵ0ᐵ()ᑣἭ᱄⊤ᑤ◀ᶍ᱄⊤%()X7ᑤ◀஺ᐭmᑣᢣ\⊤%ᐭᡈ{ᦋ()*}᝞~ᜐᳮ஺▲ᑴ\⊤ᐭᡈ{ᦋ;ᙠ᱄⊤%ᑮ0ᐵ()ᑣἭ\⊤ᐭᡈ{ᦋᶍ\⊤()X7ᐭᡈ{ᦋ஺Vrᙠ⊤45▅⊤7“9”ᐵὶklᔜ᯿᦮ឋmᑣ▭ᩭ⚞mᑣ஺ஹᵫ⊤1ஹ¡¢ᦪḄ⊤Z<ᦪ⊤¡£~ᦪḄ⊤Z<ᵫ⊤஺2ஹᵫ⊤"<¤¥ᢝ4VFP7Y᱐¨Ḅ©ªឋ«¥ᶇḄᵫ⊤4ᦪ⊤0M¤®¯ᱯឋ஺±²³ᡂµᵨᵫ⊤஺3ஹᵫ⊤X7·¸ᑮᦪ%µᐸᡂ<ᦪ⊤஺ᦪ%·¸ij¹ºADDTABLE»⊤¼½⊤·¸ᑮ$Yᦪ%஺4ஹᦪ⊤¾X7¿ᦪ%ÀÁ7ᡂ<ᵫ⊤஺ᦪ%ÀÁij¹ºREMOVETABLE»⊤¼¿$Yᦪ%ÀÁ⊤஺VrᑖÃĹºÅᙠᦪ%4ijÆÇÈᦪ%⊤Ḅ·¸4ÀÁ஺Éஹ¯ᦪ4¯⊤Ê*µᵨ*1ஹX70Ëᡭͯᦪ஺2ஹ⌱Î$Yᦪ¿“Ïᵨ”ÐᐹÒijSETDATABASETO»ᦪÓ¼

29ᐰopqrstVFPᜓὃwᧇ2010—7-16Rebuilding᦮ᳮḕᶍ“ᦪÓ”*½Õᨵ$YᦪÅᐵÖ£~ᦪÆ஺3ஹᦪḄᐵÖCLOSEDATABASES&&ᐵÖ$YᦪCLOSEDATABASESALL&&ᐵÖᡠᨵᦪ4ஹÊ*ᡭͯ⊤*⌕aØÐÙᭆÛ஺ᓽÐÙ%Ü+ᡭÍ⊤⌕ᡭͯ⊤DEᙠ¯ÐÙ%ᡭÍ஺5ஹÐÙḄÝÞ•VFPᨵ32767ḄÐÙ஺•ÐÙX7ᵨÐÙ9ᩭ⊤ß1,2,......32767o•ÐÙ¾X7ᵨᐸÃÓᩭ⊤ß:A,B,C,••…J,Wil,W12,.....,W32767o•ÐÙNX7ᵨÐÙᡭÍḄ⊤ḄÃÓᩭ⊤ß஺Å1ÆᡭÍ⊤*áᢣ'ÃÓᑣ7⊤ᦻãḄä¨Ó<⊤ḄÃÓ஺2ᡭÍ⊤*X7<⊤ᢣ'ÃÓUSE⊤ALIASÃÓ•ÐÙḄ⌱ÎijSELECTÐÙåæᡠ⌱ÎḄÐÙZ<$YÐÙ஺çᐭVFP;èÝ$YÐÙ<19ÐÙ஺éᦪSELECTÅÆêë$YÐÙḄÙ9஺ìÊ*ᡭͯ⊤஺åæᙠᦪ%¾XÊ*ᡭͯ⊤஺•ᵨUSEijᡭÍ⊤*¾X7íî½⊤ᡭÍᑮï$YÐÙUSE⊤INÐÙ$ÐÙᢣ'<0*ᢣáµᵨḄ_9ᨬñḄÐÙ஺•VFPḄ®¯4⊤ᨵᐵḄij%Å᝞GOijஹSKIPijòÆCX7¸V“INÐÙ”⌱⚗⊤ßóᢣ'ÐÙ%Ḅ⊤çô஺•¾X7µᵨï$YÐÙ%⊤Ḅõö⊤ḄÃÓᡈ⊤ᡠᙠÐÙḄÃÓ.õöÓᡈ⊤ḄÃÓᡈ⊤ᡠᙠÐÙḄÃÓ->õöÓìᙠ19ÐÙ%çô᝞úᦋû29ÐÙ%⊤Ḅ()ᢣ┐ýþᦋû;Cÿ
2⊤Ḅᑁ஺ᯠᐵ2Ḅ⊤஺6ஹ⊤Ḅᐵὶ•᯿!᦮ឋᡠ%Ḅᐵὶ&'(ᐵὶ)*ᡠ%Ḅᐵὶ+ឋᐵὶᓽ⊤ᐵ-.ᡭ0ᡠḄᐵὶ12ᨵ4஺•ឋᐵὶḄ56178⊤9“ᐵὶ;<”&>?⚗4>?A>?&BC>?2ᙠ᱄⊤᡻GHI5SETRELATIONTOᐵὶ;

30ᐰQRSTUVVFPᜓὃYᧇ2010—7-16Rebuilding᦮ᳮὶ஺%\5(1)
᱄⊤]9^_8⊤ឋᐵὶ஺`)ᐵὶHIabcADDITIVE⌱⚗ᔲᑣgᐵὶhijklm᱄⊤Ḅnᨵᐵὶ஺(2)᱄⊤ஹ8⊤+pqḄ஺ᙠ
ᐵὶḄ8⊤r]9+s
ᐵὶḄ᱄⊤஺•ឋᐵὶḄtu5B᱄⊤vwᢣ┐zk.8⊤vwᢣ┐|}zkᢣᔣpᐵvwḄ
vw஺)&vwᢣ┐Ḅὶk஺ὃ5B8⊤vwᢣ┐zk᱄⊤vwᢣ┐|}zkᔩ•
q_ᐵὶ)(
q_ᐵὶ)SETSKIPTO8⊤ᡠᙠ•ឋᐵὶḄlm(1)ᐵὶḄ⊤ᐵpᐵḄᐵὶjklm஺(2)"SETRELATIONTO"HIlm9BC⊤&᱄⊤Ḅᡠᨵᐵὶ஺(3)uSETRELATIONOFFINTO”HIlm9BC⊤&᱄⊤ᢣ⊤&8⊤Ḅᐵὶ஺7ஹ”ᦪ<”Ḅᵨ“ᦪ<”]9ᙠᡭ0⊤ஹ⊤ஹឋᐵὶ஺cT5cᑁ9⊤&᱄⊤ஹM▅⊤&8⊤9‘'”&ᐵὶ;<
ᐵὶ¡¢£᱄⊤ஹ8⊤vwᢣ┐Ḅὶk¤¥஺¦ஹ᣸¨1ஹ᣸¨+i
⊤vwᢥ᯿ª¨᣸ᑡLᡂ
gḄ⊤஺q
⊤G᣸¨¡®¯°⊤Ḅvwª¨஺2ஹ᣸¨ᡠLᡂḄg⊤&jᵫ⊤஺3ஹ᣸¨HI5²³5SORTTOg⊤ON1[/Aᡈ/D][/C],2[/Aᡈ/D][/C],........[ASCENDINGᡈDESCENDING][·][FORᩩº][FIELDS1,2,……]»¼5qBC⊤᪷<⌕¿G᣸¨ÀL
g⊤஺%\5(1)/A-ᓣ¨/D
¨ÃÄᓣ¨஺£
ÆᶍÈÉᦪ<ḄᜧËᑏ஺/A/CÍ/ACg/CA/D/C^/DC^/CD(2)ASCENDING
ᓣ¨DESCENDING
¨qÎᢣ᣸¨⌕¿ḄÏÐḄ஺(3)“·”⌱⚗ᢣÑb᣸¨Ḅvw·“FOR”⌱⚗⊤⊤vwᡈᢣ·ᑁḄvwÒÓÔÈᔠÖḄᩩº×b᣸¨஺⌱⚗Ø2ᨵᐰÙv

31ᐰQRSTUVVFPᜓὃYᧇ2010—7-16Rebuilding᦮ᳮwb᣸¨஺(4)“FIELDS”ᢣÑg⊤ᡠᒹÛḄᔲᑣ&BC⊤ḄᐰÙ஺(5)ÀLḄg⊤|jkᡭ0஺4ஹJ5qKL⊤G᣸¨LᡂKL⊤1஺᣸¨⌕¿5ᐜÝÞᓣ¨ÝÞp,9àá¨஺ᯠ¢£KL⊤1ᑁ஺cT5c☢J8஺

32ᐰQRSTUVVFPᜓὃYᧇ2010—7-16Rebuilding᦮ᳮãäSQLåÐ
ஹSQLæç1ஹSQL+q⊤GèḄ᪗êåÐ஺ᵨSQLåÐq⊤Gèëìᮣîஹïᓫ஺VFPñ᱐óôᢝSQLåÐᙠôᢝ4஺ᓽᙠᙠVFP]9ᵨSQLåÐ4஺2ஹSQLḄᐰ5StructuredQueryLanguage03ஹSQLḄ᪶÷»¼+q⊤G¢ø`ùr¼ú⊤ஹûᦋ⊤ý᪀ஹûᦋ⊤ᑁ஺4ஹr1+%ÿ
⊤ᵨᡠḄᔜVFP,ᵨᡠḄSQL஺ᵨSQL⌕ᵨVFP!஺5ஹᵨSQLḄ#$%ᜐ'()ᵨ⚜ᐜᡭ-⊤./0
⊤12SQL345⊤6ᨵᡭ-89:ᡭ-;)'

33ᐰAVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮASQ7ஹᙠ20e30%Ḅd஺SELECT*FROMd⊤WHERE=20AND=30SELECT*FROMd⊤WHEREBETWEEN20AND30Q8ஹ)ᙠ20e30%Ḅd஺SELECT*FROMd⊤WHERENOTW=20AND=30SELECT*FROMd⊤WHERENOTBETWEEN20AND30SELECT*FROMd⊤WHERENOTBETWEEN20AND30Q9ஹdḄஹஹᡠf^Ḅ^f^¡¢஺£IW!⊤BC]¤XSELECTd⊤.^f▅¡¢FROMd⊤f▅⊤WHEREd⊤.=f▅⊤.h§(!⊤BCp$¨⌕ᨵὶ0ᩩ«$j'⊤Ḅ¬ᨵ®⌕¯°஺Q10ஹdḄஹஹᡠf^Ḅ^ஹ^f^¡¢஺SELECTd⊤.]^⊤.^^f▅¡¢FROMd⊤f▅⊤,]^⊤WHEREd⊤.=f▅⊤.ANDf▅⊤.^=]^⊤.^Q11ஹfO^Ḅd஺±SELECT*FROMd⊤WHEREINSELECTFROMf▅⊤XQ12ஹ²fO^Ḅd஺SELECT*FROMd⊤WHERENOTINSELECTFROMf▅⊤XSELECT*FROMd⊤WHERENOTINSELECTFROMf▅⊤XQ13ஹfO“TP002”^Ḅd஺SELECT*FROMd⊤WHEREINSELECTFROMf▅⊤WHERE^=TP002XQ14ஹᑖ³ᓣµஹ¶µd⊤ᑁx஺SELECT*FROMd⊤ORDERBY[ASC]SELECT*FROMd⊤ORDERBYDESCQ15ஹᓣµஹ¶µd⊤ᑁx஺SELECT*FROMd⊤ORDERBYDESCQ16ஹᨬᜧḄ¸°஺SELECTTOP3*FROMd⊤ORDERBYDESCQ17ஹ¹40%ḄdWd⌕º'ᢥᓣµ᣸ᑡḄX஺SELECTTOP40PERCENT*FROMd⊤ORDERBYUV(TOP⌱⚗⌕eORDER⌱⚗$Àᵨ஺Q18ஹºdÁᦪ஺SELECT*FROMd⊤SELECTCOUNT*FROMd⊤

34_____________________ᐰAVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮQ19ஹºfO^ḄdÁᦪ஺SELECTDISTINCTFROMf▅⊤SELECTCOUNTDISTINCTXFROMf▅⊤UV(COUNTÃᦪḄ9ÄÅÆE'*ᡈÉmÊË⚗)E'!mÊË⚗஺Q20ஹºe஺SELECTFROMd⊤SELECTSUMWXFROMd⊤Q21ஹºÌᙳ஺SELECTAVGWXFROMd⊤Q22ஹºf^ὅḄÌᙳ஺SELECTAVGWXFROMd⊤WHEREINSELECTFROMf▅⊤XQ23ஹºᨬᜧஹᨬÏ஺SELECTMAXWX,MINWXFROMd⊤Q24ஹÐÑmÁḄf^ᦪ஺SELECT,COUNT*FROMf▅⊤GROUPBYQ25ஹ)Òf$^Ḅdf^ᦪ஺SELECTCOUNT*FROMf▅⊤GROUPBYHAVINGCOUNT*1Q26ஹ)Òf$^Ḅdஹf^ᦪ஺SELECTd⊤.COUNT*FROMf▅⊤d⊤WHEREd⊤.=f▅⊤.GROUPBYd⊤.HAVINGCOUNT*1Q27ஹn“Ó”ᡈ“Ô”Ḅd஺SELECT*FROMd⊤WHERE=ÓOR=ÔSELECT*FROMd⊤WHERE=ÓUNIONSELECT*FROMd⊤WHERE=Ô’Q28ஹÖËÑmf^ὅᨬ×Ḅf^஺SELECT,^,MAXWf▅¡¢XFROMf▅⊤GROUPBY(_1WÑmf^ὅᨬ×Ḅf^XSELECT^f▅¡¢FROMf▅⊤XXWHEREf▅¡¢=SELECTMAXWf▅¡¢XFROMf▅⊤WHERE=XX.XQ29ஹØQ11⚪஺Ú“ᑡ11SELECT*FROMd⊤WHEREEXISTSSELECT*FROMf▅⊤WHERE=d⊤.XQ30ஹØQ12⚪஺SELECT*FROMd⊤WHERENOTEXISTSSELECT*FROMf▅⊤WHERE=d⊤.XQ31ஹᙠ“2003003”dᨬ×f^¡¢%¹Ḅf^ÛÜ஺SELECT*FROMf▅⊤WHEREf▅¡¢"SELECTMAXWf▅¡¢X

35ᐰAVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮFROMf▅⊤WHERE=2003003XSELECT*FROMf▅⊤WHEREf▅¡¢Ý=ANYSELECTf▅¡¢FROMf▅⊤WHEREdZtXBOCBXÞ(ANYßà'(áâ$m஺Q32ஹᙠ“2003003”dᨬ×f^¡¢%Ḅf^ÛÜ஺SELECT*FROMf▅⊤WHEREf▅¡¢ுSELECTMAXWf▅¡¢XFROMf▅⊤WHERE=2003003XSELECT*FROMf▅⊤WHEREf▅¡¢ுALLSELECTf▅¡¢FROMf▅⊤WHERE=2003003XÞ(ALLßà'(ᡠᨵ஺Q33ஹ“Ó”Ḅd஺SELECT*FROMd⊤WHERE=ÓSELECT*FROMd⊤WHERELIKE'Ó*P120Q5.12X(äPQåP142⚪1஺2ஹ⊤Ḅὶ0{BCᦪZæᑮèm⊤pP▭ᐜê$m⊤Ḅὶ0%ᡂ2$m⊤ᯠᙠὶ0Ḅ⊤cBC஺ᑖ᪆Q9ḄBCOî(Q9ஹdḄஹஹᡠf^Ḅ^f^¡¢஺SELECTd⊤.^f▅¡¢FROMd⊤f▅⊤WHEREd⊤.=f▅⊤.9Wὶ0]¤XVFPcὶ0ïᵨ#᜜Ḅñò(•ᑁôὶ0ᱯö(÷
øᔠὶ0ᩩ«ḄÛÜὶ0஺SELECTd⊤.^f▅¡¢FROMd⊤JOINf▅⊤ONd⊤.=f▅⊤.SELECTd⊤.^f▅¡¢FROMd⊤INNERJOINf▅⊤ONd⊤.=f▅⊤.úûü(SELECTd⊤.^f▅¡¢FROMd⊤f▅⊤WHEREd⊤.=f▅⊤.SELECT*FROMd⊤INNERJOINf▅⊤INNERJOIN]^⊤ONf▅⊤.^=]^⊤.^ONd⊤.=f▅⊤.úûü(SELECT*FROMd⊤f▅⊤]^⊤WHEREf▅⊤.^=]^⊤.^ANDd⊤.=f▅⊤.•ýὶ0

36ᐰAVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮᱯö(ᙠᑁôὶ0ḄþẠ
⊤ὶḄ஺SELECT⊤.


▅FROM⊤LEFTJOIN▅⊤ON⊤.=▅⊤..•ὶᱯᙠᑁ"ὶḄ#Ạ
⊤ὶḄ஺SELECT⊤.


▅FROM⊤RIGHTJOIN▅⊤ON⊤.=▅⊤.•ᐰὶᱯᙠᑁ"ὶḄ#Ạ
⊤ஹ⊤ὶḄ'ᐭ஺SELECT⊤.


▅FROM⊤FULLJOIN▅⊤ON⊤.=▅⊤.)*+ᵨᑁ"ὶ-.஺/0⊤123456ὶ஺᝞P125SELECTS.8ᕒ
“⚞<”,E.8ᕒFROM8ᕒS,8ᕒEWHERES.8ᕒ=E.?ᳮAB56ὶCD.E3ஹᦋGHIJKḄLᔣ•NOPQR
SELECTḄHIJKSᙠ/0TU“HI”ḄVW⊤஺•YHIJKSᑮᦪ\SELECT]^INTOARRAYᦪ\_`aᦪ\ᵨ⚜ᐜde
fghᦪ\஺ijYHIJKSᑮ/0ᦪ\
ᯠlᵨLISTMEMORY]^Hmᦪ

37o஺•YHIJKSᑮᢣdḄVW⊤SELECT]^INTOCURSORᦻrᐵtVW⊤l
VW⊤ᦻr5uᑤ◀஺♦YHIJKSᑮᢣdḄxy⊤SELECT]^INTOTABLE/DBFᦻraxy⊤f5ᵫ⊤஺•YHIJKSᑮᢣdḄᦻ{ᦻrSELECT]^TOFILEᦻrLADDITIVE]ᦻ{ᦻrNO᡽}fTXT஺•YHIJK~〈ᑮᡭᓺSELECT]^TOPRINTER[PROMPT]•YHIJKᑮSELECT]^TOSCREENijᑴ”⊤.DBF”ᑮ“⊤2.DBF”஺ஹSQLḄU1ஹSQLḄUᢣ⊤ᑁḄஹIJஹᦋ஺

38ᐰgVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ2ஹḄ]^1INSERTINTO⊤(¡1,¡2,........)£VALUES(¡1ᑁ,¡2ᑁ
……)¥ᔣ⊤ᐭ“2003111“
W”
18஺]^2INSERTINTO⊤FROMARRAYᦪ\Yᢣdᦪ\ᑁUfᑁᐭᑮ⊤஺ᦪ\23¦/hᡈghᦪ\஺_`¨¦/hᦪ\
ᑣª/0«¨¦ghᦪ\
ᑣ¬0(/⊤/0)஺]^3INSERTINTO⊤FROMMEMVARY®ᑁ¯G°ᑁUf¡ᑁᐭᑮ⊤஺3ஹḄ±ᦋ]^UPDATE⊤SET¡1=ᑁ
¡2=ᑁ
……WHEREᩩr£Y⊤³ᔠᩩrḄᡈᐰ"ᢥ⌕·¸¹஺¥Y⊤º»¡¼1஺4ஹḄᑤ◀]^DELETEFROM⊤WHEREᩩr£½¾ᑤ◀⊤³ᔠᩩrḄᡈᐰ"஺¿ஹSQLḄde1ஹSQLḄdeᢣ⊤J᪀Ḅdeஹ±ᦋÁ஺2ஹ⊤Ḅde•_`(1)⊤Ḅde+ᵨCREATETABLE/DBF]^஺de⊤W
¨ᨵÃÄᦪÅÆ
Ç]^ÈÉᢣ`ÊË5ᵫ⊤
ᑣᡠdeḄ⊤¦ÍÎÃÄᦪÅÆḄ⊤
ᔲᑣf5ᵫ⊤஺(2)de⊤W-
fÑÒ¡ÓÔ
⌕ᵨᑮÓÔḄ⊤Õ஺ÓÔḄ⊤ÕÖP135⊤5.2஺,⊤ḄdeCREATEDATABASE×ØÙᳮ1MODIFYDATABASECREATETABLEÚÆ1(;ÚÆC(5)PRIMARYKEY,;ÛÜC(10),;☢ÞICHECK☢Þ0ERROR"☢ÞàᜧÎ0!”)CREATETABLEâã1(;ÚÆC(5)âãC(5)PRIMARYKEY,;

39ᐰgVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮãICHECKã=1000ANDã=5000ERROR”ã¼Ḅåᙠ1000-5000!,,DEFAULT1200,;FOREIGNKEYÚÆTAGÚÆREFERENCESÚÆ1TAGÚÆ)ᡈCREATETABLEâã1(;ÚÆC(5)REFERENCESÚÆ1TAGÚÆ,«âãC(5),;ãICHECKã=1000ANDã=5000ERROR”ã¼Ḅåᙠ1000-5000!?,DEFAULT1200,;PRIMARYKEYâãTAGâã)CREATETABLEæàᖪ1(;æàᖪC(5)PRIMARYKEY,;æàᖪC(20),;ᙢᙬC(20))CREATETABLE×êᓫ1(;âãC(5),;æàᖪC(5),;×êᓫC(5)PRIMARYKEY,;×êD,;FOREIGNKEYâãTAGâãREFERENCESâã1TAGâã,«FOREIGNKEYæàᖪTAGæàᖪREFERENCESæàᖪ1TAGæàᖪ)•_`(1)123Ë᎛⌱îïCREATETABLEæàᖪ1(;æàᖪC(5)PRIMARYKEY,;æàᖪC(20)UNIQUE,;ᙢᙬC(20))ᡈCREATETABLEæàᖪ1(;æàᖪC(5)PRIMARYKEY,;æàᖪC(20),;ᙢᙬC(20),;UNIQUEæàᖪTAGGYSM)(2)ᙠ4᱄⊤ᐵὶḄPQR
Ëñ)îïCREATETABLEâã1(;

40ᐰgVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮÚÆC(5),«âãCমPRIMARYKEY,;ãI,«FOREIGNKEYÚÆTAGÚÆREFERENGES..ÚÆ1)(3)ᵨFREE⌱⚗ᢣdË5ᵫ⊤CREATETABLEæàᖪ1FREE(;æàᖪC(5)æàᖪC(20),;ᙢᙬC(20))Ë5ᵫ⊤W
]^Ḅôõᵨ஺᝞CREATETABLEæàᖪ1FREE(;æàᖪC(5)PRIMARYKEY,;æàᖪC(20),;ᙢᙬC(20))3ஹ⊤J᪀Ḅ±ᦋ,]^1ö.ALTERTABLE⊤ADD/ALTER¡ÑÒ_`(1)ADDf¡
ALTERf±ᦋ¡஺(2)“¡ÑÒ”Ḅᑏø®“CREATETABLE”]^Ḅ¡ÑÒ஺¥1ᙠ×êᓫ1⊤/ØùÓÔḄ“úûü”¡
ýþàḄ¡ᨵᦔឋ
ᑣ஺ALTERTABLEᓫ1ADDYCHECK0ERROR“ᜧ0!”2ᓫ1⊤Ḅ“ᓫ”ᦋ6஺ALTERTABLEᓫ1ALTERᓫC(6)•2ALTERTABLE⊤ALTERLSETDEFAULT"#$][SETCHECKᨵᦔឋ
ᑣ[ERROR┯)*+]][DROPDEFAULT][DROPCHECK],-./ᡈᑤ◀ᢣ4Ḅ“"#$”ஹ“ᨵᦔឋ
ᑣ”஺1647ᓫ1⊤“”Ḅᨵᦔឋ
ᑣ஺ALTERTABLEᓫ1ALTERSETCHECK100ERROR“ᜧioor2ᑤ◀ᓫ1⊤“”Ḅᨵᦔឋ
ᑣ஺ALTERTABLEᓫ1ALTERDROPCHECK,39:ᵨ<ALTERTABLE⊤DROP[COLUMN]ᑤ◀஺

41ᐰ>?@ABCVFPᜓὃFᧇ2010—7-16Rebuilding᦮ᳮALTERTABLE⊤RENAMECOLUMNὁKTOLKᦋK஺ALTERTABLE⊤ADDPRIMARYKEYMN⚗TAGMNKPLDROPPRIMARYKEYLADDUNIQUEMN⚗TAGMNKPDROPUNIQUETAGMNKPADDFOREIGNKEYMN⚗TAGMQIKREFERENCESᐵὶ᱄⊤TAG᱄⊤MNKPPLDROPFOREIGNKEYTAGMNKPUVஹᑤ◀WMNஹ᎛⌱MNஹᐵὶ஺1ᓫ1⊤“”ᦋK“”஺ALTERTABLEᓫ1RENAMECOLUMNTO2ᑤ◀ᓫ1⊤Ḅ“”஺ALTERTABLEᓫ1DROP3Zᓫ1⊤Ḅ“[\+^ᖪ”MN⚗`aKZGGYSḄ᎛⌱MN஺ALTERTABLEᓫ1ADDUNIQUE[\+^ᖪTAGZGGYS4ᑤ◀b`ḄMN஺ALTERTABLEᓫ1DROPUNIQUETAGZGGYScAdeZcfgP142cA⚪2஺

42ᐰ>?@ABCVFPᜓὃFᧇ2010—7-16Rebuilding᦮ᳮijklmnopqஹlm1ஹrstSELECTlmu9ᵨᑮwxyᐸ{|}ᩭZᜓᵨ஺{|SELECTlmᡠᑮḄᦻlmᦻxlmxᐸ᡽KQPR஺qxqtlmᦻᨵqtSELECTlm஺2ஹᨵlmᦻx◤⌕ᵨᑮ☢Ḅlmwx◤᡻lmᦻᓽy஺᡻lmᦻDOlmᦻᜐlmᦻKᑏc᡽K஺3ஹlmḄ`a

43ᐰ>?@ABCVFPᜓὃFᧇ2010—7-16Rebuilding᦮ᳮ•léᡠ./lmḄlmÜÝ
Ctrl+Q•lmÎᔣḄ./÷SELECTḄINTOÏᑖᡈTOÏᑖÉëìíéᑮḄlmÎᔣî“pï”ஹ“ð⊤”®“᪗ò”ót஺íótÎᔣḄfôõö÷øùSELECTlmfôḄx¶÷ᙠSELECTlmÒúVᐸûḄÚᐵ஺•lmḄ{|lmḄ{|ᓽ“lm.?ᘤ”ᡠ»ᡂḄlm{|}ᩭ஺ülmÎᔣ./ḄëìyZéÅxrlmÎᔣ“pï”ஹ“ð⊤”ᡈ“᪗ò”wxlmᦻöáᨵqtSELECTxýᨵᐸû஺5ஹlmḄþᦋ?Ḅ@▲ᓽB%ᵨC᪀⌼DEFGᩖḄ᝞ᩩKᨵLḄ஺7ஹMᔣF“OP”ḄḄᵨ
1᡻Rᦻ᪷TᔣUVᡠ⌕YDḄOP&Rᨵᐵ(-஺
2VFP[OPYDᑮ⊤ᓫᦻ_`ᔣUḄᨬb⌕cd>⊤ᓫᦻef⊤ᓫᦻḄ᡽heFSCX஺
3᡻R⊤ᓫᦻ“DOFORM⊤ᓫᦻ”f⊤ᓫᦻ᡽heiḕᶍᓽlᑮ⊤ᓫᦻḄOP஺3iOP!mnop⊤ᔜoḄrs஺ஹO1ஹOḄtu•wxyz{|ᵨᑮ}i[~yzᶇᩭ஺ᶇᩭḄyzO஺OᑁᡠᑮḄ⊤FOḄ⊤஺•OḄᱯ
1OᙠᦪTBḄᦻ஺
2ᦪTOlᩭ>⊤஺▭Oiw⊤>᪵ᙢᵨ᝞ᡭOஹᐵOஹOᑁஹᦋOᑁ஺_`OF¡⊤஺

44ᐰ¤)¥¦§VFPᜓὃªᧇ2010—7-16Rebuilding᦮ᳮ
3O®⊤ᑁ¯°Ḅᐵ±:1⊤ᑁ³´ᩩᙢµ¶OḄᑁ᝞zO·¸¹ᡭºᐵb»ᡭ¼%lDµ¶஺2i45(-½OᦋḄᑁM¾,⊤஺•OḄ¿Àᨵ¿ÀÁḄOᙢOfÂO®ÃÄO஺ᙢO>Åᢣᵨ¦ᘤ⊤F⊤ḄOÇÃÄOᢣᵨÈÉᐸC¦ᘤḄ⊤ᡈὅ᪷ᐸCÀÁᦻf᝞ExcelᦻF⊤ḄO஺ᡃÍÎÏÐᙢO஺2ஹOḄᨵᐵÑ•OḄÒ3᝞z“SELECT*FROMop⊤WHERErs19”Ḅyz{|ᵨᑮÓ[~yzFO஺>!ÒCREATEVIEWopO1ASSELECT*FROMop⊤WHERErs19ᓄ!Òᓄ!Òᵨ“O()ᘤ”஺ᵨ“CREATEVIEW”ᡈ“,”“O”$%iÔÕ“O()ᘤ”஺ᵫÒO×⌕⌕ØᑮÙpOḄᡠiilD“O()ᘤ”ÚÛ®“()ᘤ”>᪵஺;<ÎᨵᨵwÜᦪT}¼%ÒOᡠÒḄOÝwÜᦪT஺•OḄᦋᦋOᓽᦋÙpOḄ஺>ᙠᦪT·¸ÞßO⌱á“ᦋ”஺MODIFYVIEWO•OᑁḄஹᦋOḄᐵஹᡭ஺f⊤•âã⊤Ḅᦋä᝞嵶OᑁḄ஺•(-ᵨOᑁM¾,⊤æâã¾,çè஺éf¾,(-ஹ¾,OЕ[OêᦪTëM஺ᓄìnDROPVIEWO_FOíBḄᦻᡠiOëDᦪTbîᜫÏ஺¦ðñᡠòᑁ஺

45ᐰ¤)¥¦§VFPᜓὃªᧇ2010—7-16Rebuilding᦮ᳮ6ó8Äô()Ạ>ஹÄôḄtu1ஹÄôöᡂx⚗ùúûû◤⌕ᐜb᡻Rþ஺᝞z>ùú{|⌕ÿ
ᡂḄᩭ
ᵨ஺ᡠᑮḄᦻᦻ஺ᡠ!"#ᦻḄᑁ%ᓽᡂ'(Ḅ!ᑡ஺ᡠᦻ*!ᦻ஺!ᦻ+ᦻ,Ḅ᡽./0PRG஺2ஹ!Ḅ᡻34(567“DO!ᦻ”஺9ᜐ!ᦻḄ᡽./ḕᶍ஺4=567“!”?ᓫAḄ“B3”CD஺3ஹVFP!ḄEᡂ1!ḄFG᪾IJKLMᡭOᦪQRS⊤+ᵨSQLUV⊤WXᵨ⚜ᐜᡭO⊤,[⊤\3UVᐵ^⊤SᦪQR_ឮaLMb_!cdb+2JKLMAḄeᵨLMCLEARf◀hijkḄlm஺SETTALKOFFḄCD5ᐵ^(ḄXn⌕pqlm஺+3ឮaLMAḄeᵨLMSETTALKONḄCD5ᡭO(ḄXn⌕pqlm஺rs5JKLM#ᦋuvwx᝱ḄLM(z{ᙠ!᡻3ឮaᑮvwx᝱ᡠᨵឮaLM~r஺+4!cd(!Ḅcdᜐ{ᑏkcd஺VFP!eᵨḄcdᨵ5RETURN5cd!Ḅ᡻3k!஺+!Ḅ,QUIT5cd!Ḅ᡻3⌨VFP஺(zV0ᨬk!Ḅcd஺

46ᐰ=VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ(5)!Ḅᑏ•!A(ᓰ(3(ᣚ3)஺᝞¢£¤ᙠᐭ(ᑖ§ᣚ3ᐭ஺•0¨©ª!Ḅ«ឋ!Ḅ〉ᙢ{¯k°±Ḅᑁ%஺°±ᑁ%²³#´µ!Ḅ¶µḄ᡻3!AḄW·Xᳮ¸°±ᑁ%஺VFP!AḄ°±4ᨵ¹º5»(º5NOTEOᜮḄ᦮30°±ᑁ%½»=º5*OᜮḄ᦮30°±ᑁ%½»¹º5ᙠ3&&OKÀÁ3Â0°±ᑁ%஺(6)!ÃÄÅ(PROG.PRG)4ஹ!ᦻḄÆÇ!ᦻᑁ%ḄÈÉ#ᙠ!ÈÉÊU\3Ḅ஺Ëᑡ4\ᐭ!ÈÉÊÌ54(567“ÍΔ“!”CD\ᐭ½4=567“MODIFYCOMMAND!ᦻ”\ᐭ½4¹567“MODIFYFILE!ᦻ”\ᐭ஺°Ï54=A!ᦻḄ᡽./ḕᶍÐ4¹A!ᦻḄ᡽./XDḕᶍ஺5ஹ!ᦻḄÑᦋ!ᦻḄÑᦋÒ᪵Ôᙠ!ÈÉÊÌ\3஺Ëᑡ4ᙠÑᦋ!W\ᐭ!ÈÉÊÌ54(567“ᡭO”“!”CD\ᐭ½4=567“MODIFYCOMMAND!ᦻ”\ᐭ½4¹567“MODIFYFILE!ᦻ”\ᐭ஺Ò᪵4=A!ᦻḄ᡽./ḕᶍ4¹A!ᦻḄ᡽./XDḕᶍ஺6ஹ!ḄÏÕ•ÖA¨×ØᜐᳮÙ0aᩖḄÛ⚪஺•V0ᦻ
¨Ḅᵨ஺=ஹ!AÝᓫḄᐭஹ1ஹINPUTÞß5INPUT_ᐭàmbTOᑁuÆCD5ÅáᵨᡝãäåᐭᦪQ(ᢥä)·ᡠᦪQçᐭᢣḄuÆA஺rs5•êëغìíḄᦪQ஺ᐭWᦪQḄîß#eÆᡈ(z⊤ðß஺•AḄ“ᐭàm”#⌱⚗óÎôᵨk஺•XDXᑁ%Àê஺Ä5µPROG1.PRG!஺

47ᐰ=VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ2ஹACCEPTÞß5ACCEPT[ᐭàm]TOᑁuÆCD5Åáᵨᡝãäåᐭᑁ%+ᢥä,·ᡠᑁ%V0÷øùçᐭᢣḄuÆA஺rs5Xᑁ%ÀêᑣuÆû(üùý஺Ä5µPROG2.PRG!஺3ஹWAITÞß5WAIT[àmpq][TOᑁuÆ][WINDOWS][NOWAIT][TIMEOUTÅ᎛ÿᦪ]᎛ᵨᡝᢥᡈ᪗஺ᵨᩭᨚḄ᡻஺!•ᨚ#$Ḅ%&'()%*+,-./“ᢥ1234……%&'(678ᐸ:;ᙠ=>?@A⌱WINDOWS⚗,-./DEFG஺•HᨵTO⌱⚗+-,ᵨᡝḄᢥ'(KL/MNᑁPQRᑮTUA஺ᵨᡝᢥḄVWXYᡈ᪗,TUZᑮḄ[KW\]஺•"TIMEOUT᎛^ᦪ”ᵨᩭ`abḄ+$^ᦪ,cd+$)ᢥ,K34e᡻஺f+,TUZᑮḄ[KW\]᝞hᨵTO⌱⚗Ḅi஺•j+kᵨWINDOWSlNOWAIT⌱⚗+,mW:;%&'(nob஺4ஹqᡈqqᙠqᡈHrḄs☢qqv:ᢣxḄv:⚗[஺y2ḄWs67ᑏ:{=v:⚗,|}Ḅv:⚗$7⌹ᑖ◞஺ஹḄ᪀1ஹḄ᪀ᒹ᪀ஹ⌱᪀ᑖ᪀ஹ᪀᪀஺2ஹᡠ᪀Wᢣf᪵ḄᐸAḄGe᡻஺3ஹ⌱᪀,Wf᪵Ḅᩩ)j,ᡠ᡻Ḅ)j஺;f᪀,⌕ᵨᑮᢝf᪀Ḅ¡஺4ஹ᪀,Wf᪵Ḅᙠxᩩ,¢£¤᡻{¥஺¤᡻{¥Ḅf¦/“§”஺⌕;᪀,Hᯠ⌕ᵨᑮ|©Ḅᢝ¡஺5ஹᢝ⌱᪀Ḅᩩ¡1IF¡ªIF¡«¬2CASE¡ᔛCASE¡«¬3!•/®kḄ᪀¯ᨎ,᪀AḄᑁ±²ᑖᓽ´µᑁP©᪷·ᐸµ〉H¹º»ᑏ஺f»ᑏ¼¾“¿À»ᑏÀÁ”஺

48ᐰÃÄÅÆÇÈVFPᜓὃËᧇ2010—7-16Rebuilding᦮ᳮ•ᩩ¡A67Ï:;ᩩ¡,fÐѾLᩩ¡Ḅ±ᝅ஺m⌕y2Ó¿À»ᑏÀÁ,ᩩ¡Ḅ±ᝅ)Ôᳮ¬஺•CASE¡A,Hᨵ{=ᩩᡂÖ+,mᨵᨬr☢ᩩØ©ḄᑡZᑮ᡻஺(4)ÚÛ•▅ÝPROG3.PRG•▅ÝPROG4.PRG•P163Ú7.5Þὃß%&⚪A,IF¡Ḅᩩ".NOT.EOF0”ᵨáâḄã⊤åWᦻçᨵè஺2ᓽéêᢣ┐çᨵᢣᔣ⊤í,W,G=îᑮ®NᔠᩩḄéê஺ðð,ᩩñ67ò᪵⊤&q6ஹᢝ᪀Ḅ¡(1)DOWHILE¡DOWHILEᩩ§ENDDOHᩩᡂÖ+,᡻§஺(2)FOR¡FORTU=ô[TOõ[STEPö÷ø§ENDFOR/NEXTHTU[)cdõ[+,᡻§஺TUù[ô[úû,ýsþÿ
஺(3)SCANSCANFORᩩENDSCAN┐⊤Ḅᡈᢣᑁ!ᔠᩩḄ#ᙳ᡻&'(஺(4))*•,-.᪀Ḅ012ᑏ஺•FOR#.4Ḅᩩ5“78”Ḅ“:;”“<”஺“
”=>?#“:;”@A=“ᜧC”D“
”=E?#“:;”@A=“FC”஺“
”=0?#G5'“H”#ᓽJKLᙢNO᡻&PḕᶍSTEP⌱⚗?#U=
=1஺•#VWX᡻&YLOOP[\#⊤]^XḄ᡻&_.4஺ᓽ^XLOOP[\`ENDDOᡈENDFOR/NEXTᡈENDSCANabḄ[\cKd᡻&஺•#VWX᡻&YEXIT[\#ᑣfᓽ.4Ḅ᡻&஺ᓽEXIT

49ᐰhijklmVFPᜓὃpᧇ2010—7-16Rebuilding᦮ᳮ[\᡻&t#uᓽvᑮENDDOᡈENDFOR/NEXTᡈENDSCANat᡻&஺•xyzd{|#^}~Ḅᝅ஺⌕,-012ᑏ1#ḄᝅxKᳮ஺(5)•▅PROG5.PRG,ᑏ{Ḅ஺•▅PROG6.PRG,ᑏ{Ḅ஺•▅PROG7.PRGo•ijT=1!+2!+……+10!^}⚪ij஺?;ᵨ⌲⚗Ḅ#ᓽᵨ.᪀ᑴ#Gᔜ⚗Xᑮ¡`Ḅ78஺'¢.᪀᝞¤T=0&&T¥¡`#¦#§ᯠ50஺P=1&&P⊤]⌕ᑮ`©ªḄ⚗#«⚪#¬'⚗ᯠ51஺FOR1=1TO10&&\I®17ᑮ10,ᯠ¯ᑴ᡻&10X#Xᐭ'⚗஺T=T+P&&G⚗ᑮ`#KJᨵᶧ³ᔳµP=P*(1+1)&&ᦋ7⚗=¤X⌕Ḅ⚗஺ENDFORὃVᦋ=¤☢#¸¹º஺T=0&&T¥¡`P=&&P⚗§FOR1=1TO10P=&&ij⚗஺_]⚗ᙠ¼'⚗ᓽP|ᨵ½Ạ¼¿À஺T=T+P&&⚗ENDFOR•#Á]᝞¤Âᫀ****^5'ᨵÅÆḄÂᫀ#&Ç▭¼5ᵫº1`*ÊËᡂ#Í{&º1`*ᦪÏ&ÊabḄᐵÑt#cyzᵨ'Á][\ᩭÁ]ᔜ&#Óᐸ᡻&7X#ÕÖᑮÂᫀᡠ◤ᔛ7”஺FOR1=1TO7&&ᑴÁ]7&?SPACE(7-I)+REPLICATE('*',2*1-1)ENDFOR

50ᐰhijklmVFPᜓὃpᧇ2010—7-16Rebuilding᦮ᳮὃ#ᑖÛÁ]᝞¤Âᫀ:Âᫀ1:****Âᫀ2********7ஹ▅Ïᳮ)*Uá▅`ᳮÛâᑏḄ5ã▎ᡃæஹçèéḄN⌕⌶ë஺•P1677.8•P1687.9•P1697.10•P1697.11•P1717.13•P1717.14(EXA714.PRG)•P1737.152•P1737.16(⌱)¼k¼küý᡻&z¼஺þஹÿᙽ1ஹᙽḄ஺ᜧḄᵨᵫ

51ᐰVFPᜓὃ#ᧇ2010—7-16Rebuilding᦮ᳮᙽ'ᡂḄ)*ᙽ+ᡂ,-./0-.1)'ᔠᙠ4+ᡂ᦮Ḅ-.஺567CXMK1.PRG89ᙽ஺2ஹᙽ:;<ᵨ=ᙽ஺ᐸ?)@<ᵨḄᙽAB0)<ᵨḄᙽABC)ᨬEFḄ<ᵨᙽABCG஺3ஹVFP?)ᙽḄ⊤IJK67JKLM7JK஺
17JKLM7JKḄ89567CXMK2.PRG897JKLM7JKᙽ஺
2NO7JKᙽḄPK6PROCEDURE/FUNCT1ON7QRSᑡrENDPROC/ENDFUNC]•PRGᦻW?):;ᨵM7JKḄᙽ)7JKḄᙽ)YM7JKḄᙽ⌕ᑏᑮ]☢஺_᪵ḄPRGᦻWabᦻW஺᡻d_᪵ḄᦻWe)⊤f᡻dᐸ?ḄM7JKᙽ)7JKᙽgᨵᙠ@<ᵨeh᡻d஺<ᵨe)7JKᙽ;ᐸ7Qᩭ⊤f஺•PRGᦻW?)k:;gᨵ7JKḄᙽ'ᡂ)_᪵ḄPRGᦻWAB7ᦻW஺7ᦻWl.@᡻d)mᐸ?Ḅᙽ:;@<ᵨ஺•7ᦻW?Ḅᙽᙠ<ᵨ])ᡭo7ᦻW6SETPROCEDURETO7ᦻW1,7ᦻW2,.......[ADDITIVE]ᙠᡭoᢇ7ᦻWe)q8rstuᐵwx]ᡭoḄ7ᦻW஺᝞zl{|ᐵwx]ᡭoḄ7ᦻW)RS?}EADDITIVE⌱⚗஺RS?)7ᦻWḄ᡽Q:;ḕᶍ஺•7ᦻW?Ḅᙽlᵨe)ᐵw7ᦻW6SETPROCEDURETO6ᐵwᡠᨵᡭoḄ7ᦻW஺RELEASEPROCEDURE7ᦻW1,7ᦻW2,……6ᐵwᢣḄ7ᦻW/7ᦻW᡽Q:;ḕᶍ1஺56CXMK2.PRG?Ḅ7JKᙽᑮ7ᦻW?஺•ᦻW?)7JKḄᙽᙠᦻW?<ᵨᓽ:)mᙠᐸᦻW?<ᵨe)⚜ᐜᡭoᡠᙠḄᦻW)<ᵨe)ᐵwᡠᙠḄᦻW஺ᦻWḄᡭoLᐵw7ᦻW஺56Fl.PRGஹF2.PRGᦻWᑁ)ᯠ⚪஺/1ᙽ¡᪆11F1.PRGᦻW£7ᦻW¤F2.PRGᕖ¤2¦§ᐳ©ª7¤3§ᐳᨵªᙽ¤4ஹᙽḄ<ᵨ
1M7JKᙽPK6DOᦻW

52_____________________ᐰVFPᜓὃ#ᧇ2010—7-16Rebuilding᦮ᳮ_¬PKe)ᦻW᡽Q:;ḕᶍ஺PK6ᦻWQ()(2)7JKᙽPK6DO7QPK67Q()(3)NOPK<ᵨJK°:;±RS²ᵨ)k:;±³ᦪ²ᵨ஺±³ᦪ²ᵨe-)³ᦪ¶Bᙽ?RETURNRS·Ḅ¶6RETURN⊤¸K஺᝞zRETURNRS¹ᨵᢣ·¶)ᡈᙽ?»ᾪḕᶍRETURNRS,ᑣ·¿¶஺5ஹᙽ<ᵨeḄÀᦪÁ⌴(1)ÀᦪÁ⌴ᢣ6ᙽ<ᵨ=ᙽe):;7Àᦪᔣ@<ᵨᙽÁ⌴ᦪÄÅ@<ᵨᙽ᡻d)k:;7Àᦪᔣ<ᵨᙽ·ᦪÄ஺(2)ᙽ⌕Æᙠ@<ᵨe.Ç7ÀᦪÁ⌴ᦪÄ)ᑣḄÈRSÉÊ…ÀᦪRS6PARAMETERSÀᦪ1,Àᦪ2,.......NO6•ÀᦪRS?ḄÀᦪbËKÀᦪ)ÌAËÀ஺ËÀg.ᵨQAᩭ⊤f஺7JKᙽḄÈRSᢣPROCEDUREᡈFUNCTIONxḄRS஺(3)<ᵨÍÀᦪRSḄᙽe)ÉÊᔣᐸÀᦪÎÏÐ▭ᑁ6PK6DOᙽWITHÀᦪ1ᑁ)Àᦪ2ᑁ)……PK6ᙽ(Àᦪ1ᑁ)Àᦪ2ᑁ)……)<ᵨe)ÎÏḄÀᦪᑁbÐ▭Àᦪ)ÌAÐÀ஺ÐÀ:;ÒஹÓÒᡈÔ⊤¸K஺(4)ÀᦪÁ⌴ᑖ᪆KPK<ᵨJKÖ±ÐÀlÓÒe…<ᵨe6ÐÀ¶Á×ḄËÀ஺·e6ËÀ¶lÁ⌴×ÐÀ஺±ÐÀÓÒe…<ᵨe6ÐÀ¶Á×ḄËÀ஺·e6ËÀ¶Á⌴×ÐÀ஺]¬ÀᦪÁ⌴JKABᢥ¶Á⌴)¬ÀᦪÁ⌴JKABᢥÙᵨÁ⌴஺Ú1(ÀᦪÁ⌴ᑖ᪆)ÛPK<ᵨJKÖ±ÐÀlÓÒe…ᢥ¶Á⌴±ÐÀÓÒe…:;ᢥ¶Á⌴)k:;ᢥÙᵨÁ⌴஺q8ᢥ¶Á⌴஺

53ᐰVFPᜓὃ#ᧇ2010—7-16Rebuilding᦮ᳮᦋÓÁ⌴JKRS:SETUDFPARMSTOVALUE/REFERENCEK5ÞP1775718஺ẑ/ÀᦪÁ⌴Ð516ஹᑁàÓÒḄáᵨâ/11ᑁàÓÒḄáᵨâᓽᑁàÓÒḄᨵᦔå஺;áᵨâḄlᩭᑜᑖᑁàÓÒ)ᨵçᐳÓÒஹèᨵÓÒLéêÓÒë¬஺2çᐳÓÒᙠìíᙽ?:;²ᵨḄÓÒABçᐳÓÒ஺RSîï?ðñḄÓÒçᐳÓÒ஺ᙽ?ðñçᐳÊᵨPUBLICRSòdóO6PUBLICÓÒ1,ÓÒ2,……/3èᨵÓÒg.ᙠᐸðñᙽôᐸ<ᵨḄtFᙽ?²ᵨḄÓÒABèᨵÓÒ஺ᙽ?)ÔJKðñḄÓÒèᨵÓÒ஺4éêÓÒ/ᙢÓÒ1g.ᙠᐸðñᙽ?²ᵨḄÓÒBéêÓÒ஺éêÓÒÊᵨLOCALRSòdóO6LOCALÓÒ1,ÓÒ2,……ö÷6LOCALRSLLOCATERSḄ]øùú)²ᵨÌᑏLOCA⊤fLOCATERS஺56ᶇ/áᵨâÐ51/5:;üý.ÇáᵨᑮþᙽḄÓÒ6PRIVATEÓÒ1,ÓÒ2,.......PRIVATEALLLIKEÿPRIVATEALLEXCEPT
⎽ᵨLOCALᐹᨵḄ#$%ᡠᙠḄ(ᙽ*PRIVATEḄ#+,%ᡠᙠḄ(ᙽ*-ᒹ/ᵫᡠᙠ(ᙽ1ᵨḄ23(ᙽ஺P1817.225ᵨ26ஹ891:1ஹ89᡻<=┯?@=AB''89┯D"FGH☢J┯DKL஺MA5N⌱P“RS”UVW89Ḅ᡻<*X᪷Z[\ḄKL]=┯D஺A5^_2┯D`=ᙠᐝ᪗ᡠᙠ<஺2ஹᙠ“89┯D”FG=cX⌱P“ᢞe”⊤\ᨚh89᡻<ᙠij┯DXᙠFGkᐭ“RESUME”X89mn=┯ᜐpq᡻

54ᐰ~VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ3ஹw89Vᨵ᡻<+ᢥESCz

55ᐰ~VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ©ª£⊤ᓫ¬NᵨAஹ⊤ᓫᐭ1ஹᡃ¯MHᡠḄ⊤ᓫ%ᢣNᵨ89Ḅ±☢`%ᡃ¯²ḄFG஺⊤ᓫᓽNᵨ89±☢Ḅ஺´B89µᨵAB¶·¸¹ºḄஹ᧕¼½Ḅ±☢%Windows᛻2¿89ḄÀ¢⌕Â஺Ã\mprog3.prg89ᦋ⌼WindowsÆÇḄ89஺2ஹVFPV⊤ᓫᙠ“⊤ᓫᘤ”FGᑁÉ<஺⊤ᓫÊᵨËᓄ½ÍÎeᩭвÍÑஹ¨᧕஺3ஹ⊤ᓫÒ◤⌕ᔣ⊤ᓫÕÖ×᝞ᦻÙஹᦻ¢᪾ஹᢥÛÜÝᡂᐗà஺⊤ᓫḄMáÝᡂᐗàᡃ¯âãä஺4ஹVFPV⊤ᓫᐙᑖᑭᵨJ☢ᔣ¿èᢈêᓽm᦮B⊤ᓫëᐸ⊤ᓫḄãäµᳮì…BAB“¿è”஺M᪵îᜧᜧÍÑJᡃ¯ḄðᙠÉ<⊤ᓫ`?ñᨵòó஺5ஹ¿èḄô•¿èᐹᨵ+öḄᱯøVFPV¿èḄᱯøùúឋ஺᝞AB¶ËAB¿èḄüᐸýþ`%ÿḄ
ឋ஺•ᐹᨵḄ“”VFPḄ“”஺᝞

ḄḄ
஺VFPḄ!"#$ᵨ஺•&'()*+஺᝞'⍝ᜩ.Ḅ/ᨨ1ᓄ3஺6ஹᙠ“⊤ᓫ89ᘤ”89⊤ᓫḄ
;<=>?1⊤ᓫ8@
)Aᐵឋ?᝞⊤ᓫ᪗⚪ஹ⊤ᓫᜧF3G⊤ᓫḄAᐵ*+HIṹ?ᓽIᑏ(
*+MNO⌕᡻ḄRST*+UṹG஺?2ᔣ⊤ᓫWXᡠ◤⌕Ḅ[+\])[+8@^AᐵឋஹIᑏ^Aᐵ*+Uṹ஺3_`⊤ᓫ஺89^Ḅ⊤ᓫ_`OabN
⊤ᓫᦻ+d
⊤ᓫᜓfᦻ+஺⊤ᓫᦻ+Ḅ᡽hiSCX,⊤ᓫᜓfᦻ+Ḅ᡽hiSCT஺ᡃklm⊤ᓫᦻ+nᵨ⊤ᓫ⊤ᓫᜓfᦻ+ᡃkᩭpqr`ᙠ
᪵஺7ஹ⊤ᓫḄ᡻“DOFORM⊤ᓫᦻ+”RS!"᡻⊤ᓫᦻ+஺⊤ᓫᦻ+᡻Otuvᡃkᡠ89Ḅwxy☢஺"DOFORM⊤ᓫᦻ+”RS⊤ᓫᦻ+Ḅ᡽hiSCX!"ḕᶍ஺⊤ᓫᦻ+᡻Oᡃk!"ᙠtuḄy☢}wx஺ᡃkḄwx~ᩭA*+ḄMN*+ḄMN~A*+UṹḄ᡻ᡂvᡃk

56ᐰ9VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮwxᡠ⌕uḄ஺ஹ“⊤ᓫ89ᘤ”nᵨ1ஹ“⊤ᓫ89ᘤ”ḄHᐭ•⌱“”“⊤ᓫ”஺?
⊤ᓫnᵨG•⌱“ᡭ”“⊤ᓫ”஺?ᦋ
⊤ᓫnᵨG,lmRS>CREATEFORM>
¡i⊤ᓫ஺ᙠ¢
£_`⊤ᓫ¤¥¦ᦻ+i§¨@஺CREATEFORM⊤ᓫᦻ+>ᢣªḄ⊤ᓫ஺⊤ᓫᦻ+Ḅ᡽hi!"ḕᶍ஺MODIFYFORM>ᦋ⊤ᓫ஺⌕ᦋḄ⊤ᓫᦻ+᪾⌱஺MODIFYFORM⊤ᓫᦻ+>ᦋᢣªḄ⊤ᓫ஺⊤ᓫᦻ+Ḅ᡽hi!"ḕᶍ஺2ஹHᐭ“⊤ᓫ89ᘤ”OḄ¬uHᐭ“⊤ᓫ89ᘤ”O
;®¯°ᡃka±ᑮ>•³ᓫ´µt
“⊤ᓫ”³ᓫ¶•tu
“ឋ”·¸¶•tu
“⊤ᓫ[+”¹ᐹ´¶•tu
“⊤ᓫ89ᘤ”¹ᐹ´஺ºᐵ»“⊤ᓫ89ᘤ”¹ᐹ´_ᶇ“⊤ᓫ[+”¹ᐹ´d“ឋ”·¸஺3ஹ“⊤ᓫ[+”¹ᐹ´d“ឋ”·¸Ḅᐵ»½¾¿4ஹ⊤ᓫ[+ḄWXஹ⌱ஹᜧFᦋ1ஹÀÁஹÂᑴஹÄஹᑤ◀5ஹ⊤ᓫḄ_`6ஹ⊤ᓫḄÇÈஹÈÉ᝱Ëᑮ89É᝱7ஹ⊤ᓫ§[+ឋḄ8@Ì¿>ᙠ⊤ᓫ}Í@Îᢥб±ÑkḄÒÓiᯠOᑖÖᦋianldan2o8ஹ⊤ᓫ§[+*+UṹḄIᑏÌ¿>⌕×ᓫØanlᢥо¿t“ÙÚÛᓫØᡃvÜ”¥¿ÝÞ஺ßὃ>¥¿ÝÞàḄà*+MN¾¿á¥¿>¥¿ÝÞḄ¾¿!"nᵨ>Wait“ÙÚÛᓫØᡃvÜwindowsᡈMessagebox“ÙÚÛᓫØᡃvÜ”,64,”ᢥÐp……”Gpä>?1*+Uṹ!"lmåæRSᦋ1ḄឋÌ¿>⌕×çØ⊤ᓫ~⊤ᓫḄ᪗⚪ᦋ“èéêëVFP!”~⊤ᓫ}an2ᢥÐḄᦻìᦋ“⌨t”஺ßὃ>ᙠàḄà*+MNu᥿>Thisform.caption="èéêëVFP!”

57ᐰ9VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮThisform.an2.caption="⌨t"2*+Uṹï!"$ᵨḄÌ¿>⌕×ᓫØan2ᢥÐOᐵ»⊤ᓫ஺ßὃ>ᐵ»⊤ᓫᙠàḄà*+MNH᥿>Thisform.release?3Ḅ*+Uṹ
mðñᙠUṹ·¸mðḄòóôuPROCEDUREmði”ᡈ“FUNCTIONmði”§mðḄõöóô“ENDPROC"ᡈ"ENDFUNC”ᙳ⌕ᑏ஺4Thisform⊤¿øù⊤ᓫThis⊤¿øù஺9ஹ[+Tabú£ûḄ8ª•ᡠüTabú£ûᢣ>ᓫØTabúᯖþᙠ[+ÿḄ
஺•TabḄᨵᢥᑡ⊤஺஺஺10ஹ“⊤ᓫᘤ”Ḅᐵ$%ஹ⊤ᓫḄ&ᵨ(ឋஹ*+ஹ,ᦪ./᛻1ஹ&ᵨ(ឋ,AutoCenter•BackColor•BorderStyle•Caption⊤ᓫḄ᪗⚪•Closable•Icon⊤ᓫᢣ4᪗564᪗ᦻ+᡽9:ICOo•MaxButton•MinButton•Movable•Name⊤ᓫ;<Ḅ:=•Picture•Visible•WindowType⊤ᓫ>?1■BC⊤ᓫᐵ$D⊤ᓫEFGᐸI⊤ᓫJ0.LBC⊤ᓫᐵ$D⊤ᓫEGᐸI⊤ᓫ஺MBCஹLBC⊤ᓫḄN஺O⊤ᓫBC.sex56⊤ᓫPQ⊤ᓫᜧSTUVWWidthOXYZHeightO[YZ\(ឋᩭ^Q_V&VW`⊤ᓫa᪾Ḅcd^஺2ஹ&ᵨ*+•Load*+eᐭ⊤ᓫPgh•Init*+ijᓄ⊤ᓫPgh

58ᐰmnopqVFPᜓὃtᧇ2010—7-16Rebuilding᦮ᳮ•Destroy*+⊤ᓫᐵ$Egh•Unload*+⊤ᓫᐵ$Pgh•Click*+ᙠ⊤ᓫyᓫz{᪗|Pgh•DblClick*+ᙠ⊤ᓫy}z{᪗|Pgh•RightClick*+ᙠ⊤ᓫyz{᪗~Pgh3ஹ&ᵨ•Release◀⊤ᓫQᓽᐵ$⊤ᓫ஺,Refresh:⊤ᓫᑵ஺•Show⊤ᓫ஺•Hide◚⊤ᓫ஺4ஹᦪ./᛻•⊤ᓫḄᦪ./᛻⊤ᓫᜓᵨ⊤஺⊤ᓫḄᵨ⊤ᑮᦪ./᛻QGᑮ⊤⊤ᓫḄeᐭᡭQ⊤ᓫḄᐵ$ᐵ$஺•ᦪ./᛻Ḅ“ᦪ./᛻”Ḅᡭ,ᐵ$J⊤Ḅ,
஺•ᦪ./᛻QTU\⊤Pᐵὶ஺O`᱄⊤Ḅᐵὶ=£ᑮ¤⊤Ḅ¥ᐵ¦§Z56ᦪ./᛻^ḄPᐵὶᙠ⊤ᓫ¨eᐭP©ª«஺5ஹ¬®¯⊤ᓫQ¥ᐵ(ឋ°±^Qᓫz⊤ᓫPQG“²³´⊤ᓫµ”,~z⊤ᓫPQGᐵ$⊤ᓫ஺·ஹ᪗¸OLabel¹+1ஹ᪗¸¹+ḄN•ᵨᙠ⊤ᓫyº»஺“⊤ᓫ¹+”¼ᐹ¾N᪗¸¹+஺2ஹ&ᵨ(ឋ,Name᪗¸Ḅ:=,AutoSize᪗¸ᜧSᔲ«᪗¸ᑁÁÂᜧS•Caption᪗¸ᡠḄᑁÁ•Font*᪗¸ᑁÁḄ=Äஹ=ÅÆ,ForeColor᪗¸ᑁÁḄÇ⁐,Visible᪗¸ᑁÁᔲT3ஹ&ᵨ*+•Click*+ᓫz᪗¸Pgh•DblClick*+}z᪗¸Pgh4ஹ&ᵨÉ5ஹM¤M1ᙠ⊤ᓫy^%\᪗¸QÊᓫzᐸËÌ®\᪗¸PQÍ\᪗¸Ḅᑁ

59ᐰmnopqVFPᜓὃtᧇ2010—7-16Rebuilding᦮ᳮÁ©ᣚ஺M2:ᙠ⊤ᓫy^®᪗¸QÊᓫzIP-Q=ÅÐᜧQ~zIPQ=ÅÐS஺ÑஹÒÓᢥÔOCommandButton¹+1ஹÒÓᢥÔ¹+ḄN•ᵨᙠÕᓫzÖ᡻d®ḄØG஺“⊤ᓫ¹+”¼ᐹ¾NÒÓᢥÔ¹+஺2ஹ&ᵨ(ឋ,NameÒÓᢥÔḄ:=,EnabledÒÓᢥÔᔲTᵨ•DefaultÒÓᢥÔᔲÙḕOÛZᢥÔ஺ÊÙḕOÛZᢥÔPQᢥÜÝᓽ⊤ᓫzÞßᢥÔ஺®\⊤ᓫQàGᨵ®\ᢥÔÙḕOÛZᢥÔ஺56ÊᯖâᙠᢥÔyP;ᢥÜÝᡈ¯åᙳ⊤ᓫzDᢥÔQçßQÙḕᢥÔḄᦔéᙠê±ëì⊤íFîᩭ஺•CancelÒÓᢥÔᔲïðᢥÔ஺ÊïðᢥÔPQᢥESCᓽ⊤ᓫzÞßᢥÔ஺®\⊤ᓫQàGᨵ®\ᢥÔïðᢥÔ஺•CaptionÒÓᢥÔyᡠḄᑁÁ஺D(ឋᑁÁQ᝞éò\=óEôᵨÞᑣD=óöìᑜøḄ=óQ⊤D=óê\ÒÓᢥÔḄùú஺ÒÓᢥÔḄùúêûÜ*ÊᯖâFᙠDÒÓᢥÔPQᙠᢥìùúᡈAlt+ùúPQ⊤ᓫzÞDÒÓᢥÔ஺•Font*ÒÓᢥÔyᡠᑁÁḄ=Äஹ=ÅÆ,ForeColorÒÓᢥÔyᡠᑁÁḄÇ⁐•VisibleÒÓᢥÔᔲT,PictureÒÓᢥÔyḄ4ü3ஹ&ᵨ*+•Click*+ᓫzÒÓᢥÔPgh4ஹ&ᵨÉ5ஹM¤Mᙠ⊤ᓫy^·\ᢥÔQᢥÔyḄᦻ=ᑖþy®\ஹì®\ஹÛஹïð஺⌕
“”ᢥḄP,“”ᢥḄN,“”ᢥḄ0,“”ᢥḄC஺⊤ᓫḄᵨ஺ஹᢥ!"CommandButtonGroup#$1ஹᢥ!#$Ḅ%&•)ᵨ
*+,-ᢥ஺“⊤ᓫ#$”.ᐹ01%&ᢥ!#$஺2ஹ2ᵨ3ឋ

60ᐰ6789:;VFPᜓὃ>ᧇ2010—7-16Rebuilding᦮ᳮ•Name
ᢥ!ḄBC,Enabled
ᢥ!DᔲFᵨ•BackStyle
ᢥ!ḄG◣DᔲIJ,BorderStyle
ᢥ!K᪾MḄ᪵O•ButtonCount
ᢥ!1ᢥḄᦪ஺Q%2஺•Buttons
ᦪ!R3ឋButtons(1)⊤ST!1ḄUᢥButtons(2)⊤ST!1ḄU:ᢥ……•value
WᵨᡝᓫYZ!1ḄUᢥ[ᐸ]1,WᵨᡝᓫYZ!1ḄU:ᢥ[ᐸ]2,……^J
(1)ᢥ!D_`aᡠᒹdḄeᢥfgD_`ᡠhaᡠᒹdḄeᢥfgᨵ3ឋஹj$klm(op☢Ḅᢥ)஺(2)3ឋst1ᢥ!1ᢥ3ឋḄu,஺(3)j$vṹ1ᢥ!1ᢥ3ឋḄu,஺Ꮇuᢥ!ḄBCanz,ᐸ1U--ᢥḄBCanl,z[⌕⊤SanlḄCaption3ឋ|z᪵ᑏ
ThisForm.anz.an1.CaptionᡈThisForm.anz.Buttons(1).Caption3ஹ2ᵨj$•Clickj$
ᓫYᢥ!1ᢥ[^J
᝞ᡃᑏZᢥ!ḄClickj$vṹᑏZᢥ!1ᢥḄClickj$vṹᑣᢥᓫYᐜ᡻ᢥḄClickj$vṹᶍᢥ!ḄClickj$vṹ஺4ஹ2ᵨlm5ஹᢥ!1ᢥ᤮+,Ḅ᦮6ஹ
ᙠ⊤ᓫ+,ᢥ!ᐸ1ᒹdᢥ஺⌕
ᓫYᢥ[ᢥᦻC஺ᑖᵨᢥḄᓫYj$vṹkᢥ!ḄᓫYj$vṹᩭ¡¢஺£S
¤⁐⊤S
RGB(¦§)¨ஹᦻ©᪾(TextBox)#$1ஹᦻ©᪾#$Ḅ%&•)ᵨ
ª«ᵨᡝḄ¬ᐭ஺“⊤ᓫ#$”.ᐹ01%&ᦻ©᪾#$஺2ஹ2ᵨ3ឋ•Name
ᦻ©᪾ḄBC

61ᐰ6789:;VFPᜓὃ>ᧇ2010—7-16Rebuilding᦮ᳮ•Alignment
u,ᦻ©᪾1ᑁ°Ḅ_±lO•Font*
ᦻ©᪾1ᑁ°ḄC²ஹC³´,ForeColor
ᦻ©᪾1ᑁ°Ḅ¤⁐•Enabled
ᦻ©᪾DᔲFᵨ•Readonly
ᦻ©᪾ᑁ°DᔲFᦋ•SelectOnEntry
¶·ᯖ¹"º᪗ᓫY¶·ᯖ¹◀᜜¾[ᦻ©᪾ᑁ°DᔲD⌱1À᝱஺•PasswordChar
u,ᓰÃ஺ᡠÄᓰÃᓽvÆᐭᑁ°Ḅó஺Wᦻ©᪾1ª«ḄDÇÈÉÊËᑮḄÍṹ´ᑁ°[|Wᦻ©᪾u,ᓰÃ஺«Value
ᦻ©᪾1Ḅᑁ°"Q%CÃR¾஺ÎÏ
ᦻ©᪾1Ḅᑁ°ÇDᡃᡠÐ៉ḄCaption3ឋ1ᑁ°஺¡▭_Óᦻ©᪾#$a᪷©ÕÖᨵCaption3ឋ஺•InputMask
×ṹu,஺×ṹḄ)ᵨDᢣᦪÙḄᐭÚÛO஺×ṹÜᵫᡠÄḄÞOÃ!ᡂeÞOÃ⊤SZ__|ᦪÙḄ⌕஺᝞×ṹ1Ú¢ZàÞOÃᑣzáCÃâã᪵ᙠᦻ©᪾1äSÚᩭåÇæçᦋ஺2èÞOÃéᐸdêèP216⊤8.15஺•ControlSource
ëu,஺ëu,ììíᦻ©᪾kîᑁïðᡈCñòëz᪵_ᦻ©᪾ḄçᦋÕD_ᡠëḄᑁïðᡈCñḄçᦋóô,_ᑁïðᡈCñḄçᦋÕD_ᦻ©᪾Ḅçᦋ஺kᦻ©᪾ëḄᑁïðᡈCñöᦻ©᪾ḄᦪÙ÷஺3ஹ2ᵨj$•GotFocusj$
ᦻ©᪾·ᑮᯖ¹[•LostFocusj$
ᦻ©᪾ᜫùᯖ¹[4ஹ2ᵨlm•SetFocus
íᯖ¹+ᑮᦻ©᪾1஺5ஹ1
u7úûü☢⌕ᐭᵨᡝBkÍṹᓫY“”ᢥòᑨþÿᵨᡝṹᑖ“ABCDEF”“123456”“ᵨ”ᐵ☢ᵨᡝṹ“ᵨᡝᡈṹ!”"#$ᯖ&'ᑮᵨᡝ)*+⌱-ᵨᡝ)Ḅᵨᡝ஺᝞1234“ᜫ6!”ᐵ☢஺ᓫ9“:;”ᢥ=>?ᐵ☢⌨A஺ᐸC⌕EF“GH”ᢥ=IJḕᢥ=“:;”ᢥ=I:;ᢥ=஺L“GH”ᢥ=IMNOPO,“:;”ᢥ=IMNOPC஺F⊤ᓫRSTUឋᩭXYᵨᡝ┯[3ᦪ஺]ὃFᵨ_`ᩭXYᵨᡝ┯[3ᦪabᔩde2FIYT⊤ᓫ⌕Efᙠ⊤ᓫhi▅kl⊤m஺⌕EFIYnafoᗐklmfqrᦋᑖtᵨᦪuv᛻ᵨᦪuv᛻xyz{|}IY஺

62ᐰYVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮhFP235h⚪1Fᦻ᪾-Tᦪ⊤ᑣ=ᢥ=ᓫ9Y+A┯+l=ᢥ=ḄERRORbhe⚪஺ஹ᪾EditBox1ஹ᪾Ḅ¡¢•¤ᵨF?¥ᵨᡝḄP¦ᐭ஺“⊤ᓫ”¨ᐹ)-¡¢᪾஺•᪾Ḅᱯ&Fᐭᑁ¬+ab®ᣚ}஺2ஹ°ᵨUឋ,NameF᪾Ḅ±•AlignmentFIM᪾-ᑁ¬Ḅ²³•Font*F᪾-ᑁ¬Ḅ±´ஹ±µ¶•ForeColorF᪾-ᑁ¬Ḅ·⁐,EnabledF᪾ᔲaᵨ,ReadonlyF᪾ᑁ¬ᔲaᦋ•SelectOnEntryFº»ᯖ&¼᪗ᓫ9º»ᯖ&◀᜜+᪾ᑁ¬ᔲ⌱-À᝱஺•HideSelectionF᪾ᜫÂᯖ&+ᔲ:;⌱-ᑁ¬Ḅ⌱-À᝱஺.t.F:;.£F:;஺•ValueF᪾-Ḅᑁ¬,ScrollBarsFᔲAÃÄÅᩩ•SelStartF᪾-⌱Hᑁ¬ḄÇÈÉM஺ÊËFÇÈÉMÌ0ÇÈm஺IY+ÍUឋaᵨ஺•SelLengthF᪾-⌱Hᑁ¬ḄÎÏ஺IY+ÍUឋaᵨ஺•SelTextF᪾-⌱HḄᑁ¬஺IY+ÍUឋaᵨ஺•ControlsourceFÐHIM஺Ñ°ᜓÊÒ±Ó|}ÐH஺3ஹ°ᵨ•GotFocusF᪾»ᑮᯖ&+l•LostFocusF᪾ᜫÂᯖ&+l4ஹ°ᵨ³ÔSetFocusF$ᯖ&'ᑮ᪾-஺5ஹeÕeFᙠ᪾-ᐭᑁ¬ᓫ9“Ö×Ø2”ᢥ=+Ì᪾-Ö×Ø2×ᑮᐸ|}⌱-஺Ùᓫ9“Úᣚ”ᢥ=$᪾-×ᑮḄØ2ᦋ“ÛÜ஺ÝஹÞ⌱᪾CheckBox1ஹÞ⌱᪾Ḅ¡¢•¤ᵨFᵨᩭ⌱-ß⚗ᑁ¬ᡈ:;⌱-஺

63ᐰYVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ“⊤ᓫ”¨ᐹ)-¡¢Þ⌱᪾஺2ஹ°ᵨUឋ,NameFÞ⌱᪾Ḅ±,AlignmentFIMÞ⌱᪾Ḅ²³,CiptionFIMÞ⌱᪾áḄᦻ±•Font*FÞ⌱᪾áᦻ±Ḅ±´ஹ±µ¶•ForeColorFÞ⌱᪾áᦻ±Ḅ·⁐,EnabledFÞ⌱᪾ᔲaᵨ,ReadonlyFÞ⌱᪾ᔲa⌱•ValueFÞ⌱᪾ḄÀ᝱F⌱-1â⌱-0஺•ControlSourceFÐHIM஺Ñ°ãÒ±Ó|}ÐH஺ãÒ±ÓÐH+⌱-À᝱Value.Lâ⌱-À᝱Value3ஹ°ᵨ•ClickFᓫ9Þ⌱᪾+l4ஹ°ᵨ³Ôä5ஹeÕeF⊤ᓫhᨵTᦻ᪾ᵨᩭᐭæᨵç᰿éḄÞ⌱᪾஺ᓫ9“”ᢥ=fqᐭὅḄæë᰿é஺hFP235h⚪2bhe⚪஺ᓝஹ⌱⚗í(OptionGroup)1ஹ⌱⚗íḄ¡¢•¤ᵨFïᵨᡝÌð⌱⚗-⌱ñT⚗஺“⊤ᓫ”¨ᐹ)-¡¢⌱⚗í஺2ஹ°ᵨUឋ,NameF⌱⚗íḄ±,EnabledF⌱⚗íᔲaᵨ,BackStyleF⌱⚗íḄò◣ᔲôõ,BorderStyleF⌱⚗íö᪾÷Ḅ᪵,ButtonCountF⌱⚗í-⌱⚗Ḅᦪ஺ù¡2஺,ButtonsFᦪíÒUឋButtons(1)⊤Íí-ḄúT⌱⚗Buttons(2)⊤Íí-Ḅú⌱⚗……•valueFüᵨᡝᓫ9ýí-ḄúT⌱⚗+ᐸ1,üᵨᡝᓫ9ýí-Ḅú⌱⚗+ᐸ2,……þõFᙠ⊤ᓫh'MýT⌱⚗íÿ
⌱⚗ᔜ⌱⚗஺⌱⚗⌱⚗Ḅᨵᐵᵨឋ᝞(1)⌱⚗ᔜ⌱⚗Ḅ᦮஺

64ᐰ#$%&'(VFPᜓὃ+ᧇ2010—7-16Rebuilding᦮ᳮ(2)⌱⚗⌱⚗Ḅᵨឋ,Name⌱⚗Ḅ./,Enabled⌱⚗0ᔲ2ᵨ,Alignment⌱⚗Ḅ345,AutoSize⌱⚗ᜧ70ᔲ᪷9⌱⚗ᑁ;<=᦮,Ciption⌱⚗>?@Ḅᦻ/•Font*⌱⚗>ᦻ/Ḅ/Bஹ/DE,ForeColor⌱⚗>ᦻ/ḄF⁐•Value⌱⚗H⌱I1JK⌱I0஺(3)ឋMN
⌱⚗⌱⚗ឋḄO஺(4)PQRṹ
⌱⚗⌱⚗ឋḄO஺ᎷOU⌱⚗Ḅ./Ixxz,ᐸWU⌱⚗Ḅ./Ixxl,X
⌕⊤@xxlḄCaptionឋ
[X᪵ᑏThisForm.xxz.xx1.CaptionᡈThisForm.xxz.Buttons(1).Caption3ஹᵨPQ•⌱⚗ḄᵨPQClickPQᓫb⌱⚗cU⌱⚗de⌱⚗⌱⚗ḄᵨPQClickPQᓫb⌱⚗defg᝞hᡃjkᑏ⌱⚗ḄClickPQRṹ
lᑏ⌱⚗⌱⚗ḄClickPQRṹ
ᑣnU⌱⚗Hᓫb
oᐜ᡻rs⌱⚗ḄClickPQRṹtuᶍ⌱⚗ḄClickPQRṹ஺4ஹᵨ4wx5ஹyzyᙠ⊤ᓫ|Uᨵ}⌱⚗Ḅ⌱⚗
~⌱⚗ḄClickPQ⌱⚗ḄClickPQ45ᑨᵨᡝ⌱Ḅ0U⌱⚗(⌕?@⌱⚗ᦻ/)஺H—■ஹᑡ⊤᪾(ListBox)Q1ஹᑡ⊤᪾QḄ•ᵨᵨᡝᑡ⊤᪾Ḅ⚗ᑁ;⌱U⚗ᡈ⚗஺.“⊤ᓫQ”ᐹᑡ⊤᪾Q஺2ஹឋ,Nameᑡ⊤᪾Ḅ./,Enabledᑡ⊤᪾0ᔲ2ᵨ•Font*ᑡ⊤᪾ᑁ;Ḅ/Bஹ/DE,ListCountᑡ⊤᪾2⌱Ḅᑁ;⚗ᦪ•Listᦪឋ஺List(1)⊤@ᑡ⊤᪾ḄWU⚗ᑁ;,List(2)⊤@ᑡ

65ᐰ#$%&'(VFPᜓὃ+ᧇ2010—7-16Rebuilding᦮ᳮ⊤᪾ḄW'⚗ᑁ;
……஺•Valueᵨᡝᑡ⊤᪾⌱Ḅᑁ;஺£ᐕ¥ᵨᡝ¦r⚗⌱
sឋIᨬ⌱⚗Ḅᑁ;஺ᵨᡝ¨Kᑡ⊤᪾¦r⌱
ᐸ©Iª«஺fgᑡ⊤᪾xForeColorឋ
ᓽᑡ⊤᪾ᑁ;ḄF⁐®ForeColoឋᩭO(X[£0°±²³Ḅᜫµ)஺3ஹᵨPQClickPQᙠᑡ⊤᪾ᓫb⌱ᑁ;de4ஹᑡ⊤᪾⌱ᑁ;Ḅ¶(1)·¸¶RowSourceTypeឋOI"©"
RowSourceឋ·¸ºᐭ¼⌹D¾◞Ḅ⌱ᑁ;஺fgX᪵O
À2¼ᙠPQRṹ=᝱ᙢÃஹÄᑡ⊤᪾Ḅᑁ;⚗஺ÅÃᑁ;⚗.
Æᵨᑡ⊤᪾ḄAdditem4wJᑤ◀ᑁ;⚗.
Æᵨᑡ⊤᪾ḄRemoveitem4w஺Additem4wÉ51⊤ᓫ.ᑡ⊤᪾.Additem(ᑁ;⚗)Ê®ᙠᑡ⊤᪾ḄᨬÅÃᢣÌḄᑁ;⚗஺4w
“ᑁ;⚗”I/Í஺Additem4wÉ52⊤ᓫ.ᑡ⊤᪾.Additem(ᑁ;⚗
)Ê®ᙠᑡ⊤᪾ÎᐭᢣÌḄᑁ;⚗
ÎᐭḄᵫ4wḄ“”ᢣÌ
ᓽ“”I1U
ÎᐭḄᑁ;⚗Iᑡ⊤᪾ḄWU⚗
“”I2ஹÎᐭḄᑁ;⚗Iᑡ⊤᪾ḄW'⚗
……Removeitem4wÉ5⊤ᓫ.ᑡ⊤᪾.Removeitem()Ê®ᑤ◀ᑡ⊤᪾ᢣÌ|Ḅᑁ;⚗஺¨“”I5,ᓽᑤ◀ᑡ⊤᪾ḄWÐ⚗஺y⊤ᓫ|Uᑡ⊤᪾
⌕®ÑஹÄᑡ⊤᪾ᑁ;
?@£Ò⌱Ḅᑁ;஺(2)ᩭ<⊤Ḅn/ÓRowSourceTypeឋOI"/Ó"
RowSourceឋ¶/Ó.஺yUᑡ⊤᪾ᩭ⌱Ôe⊤ḄÔD
ᙠÕᦻ᪾?@ᡠ⌱ÔeḄ×.ØÙ஺(3)ᩭ

66ᐰ#$%&'(VFPᜓὃ+ᧇ2010—7-16Rebuilding᦮ᳮOãMultiSelectឋḄ©OI1ᡈ஺(ë0ᡈ.£ᑣᐕ¥⚗⌱
íIXîï)⌱ᢥShiftᡈCtrlñᓫb஺᝞êòó⌱Ḅ⚗Selectedឋ᝞hᑡ⊤᪾ḄWU⚗H⌱
ᑣSelected(1)IôJ᝞hᑡ⊤᪾ḄW'⚗H⌱,ᑣSelected(2)IôJ...஺yᑡ⊤᪾⌱⚗
ᯠ?@ᡠ⌱Ḅ⚗ᑁ;஺ᓝ'ஹᔠ᪾(ComboBox)Q1ஹᔠ᪾QḄ“⊤ᓫQ”ᐹᔠ᪾Q஺2ஹᔠ᪾QᵨwUU÷ᑡ⊤᪾StyleឋOI2
⊤@÷ᑡ⊤᪾஺Xᵨw;ᑡ⊤᪾QùU᪵
ú⌕ûü(1)?@᜜þ|Ḅÿ஺(2)⌱஺3ஹᔠ᪾ᵨᔠ᪾Styleឋ0⊤ᔠ᪾஺ᵨᑡ⊤᪾!᪵#⌕%&(1)(᜜*+Ḅ-஺(2)⌱஺(3)./ᙠᔠ᪾12ᐭᑁ5஺ᡠ2ᐭḄᑁ578Textឋ./9:஺;▭+ᵨᡠ⌱=Ḅᑁ5./>Textឋ9:஺ᓝ@ஹ⊤A(Grid)1ஹ⊤AḄCD•Fᵨ&/⊤AGH(⊤Ḅᑁ5஺“⊤ᓫ”LᐹN1CD⊤A஺2ஹOᵨឋ,Name&⊤AḄPQ•Font*&⊤Aᑁ5ḄQRஹQST,ForeColor&⊤Aᑁ5ḄU⁐,Enabled&⊤AWᔲ.ᵨ•Readonly&⊤Aᑁ5Wᔲ.YZ([C.\ᦋ)•RecordSourceType&⊤Aᑁ5Ḅ^_஺0-ᩭaᦻᢣdḄ⊤1-PᢣdḄ⊤([Ce)3-ᩭafghᦻ4-ᩭafSQLghjk஺,RecordSource&ᢣd⊤Aᡠ⌕(Ḅᑁ5஺lRecordSourceTypeឋᨵᐵ஺3ஹ⊤Aᵨᵨ⊤A(od⊤ᑁ5p&ᙠ⊤ᓫ+q…(st⊤ᑁ5Ḅ⊤A⌕u⊤Aᑁ5\ᦋ஺v&./>ᦪxy᛻{|1}~⊤Ḅ᪗⚪N⊤ᓫᩭ;஺

67ᐰVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ4ஹ⊤Aᵨᵨ⊤A(od⊤ᑁ5p1:ᙠ⊤ᓫ+qᑡ⊤᪾⌱=LF([C)1Ḅ⊤ᯠᙠ⊤A1(⊤ᑁ5஺ᑡ⊤᪾Clickṹ&if'.dbf$thisform.combol.valueuse(thisform.combol.value)aliasxx&&ᙠ⊤Hᔠ(thisform.combol.value)ffl¡ᣚthisform.gridl.recordsource='xx'endif⊤ᓫDestroyṹ&closedatabasep2&ᙠfᦻ£᪾12ᐭ¤¥ᯠ>st⊤1g¦§8¤¥Ḅst¨©ghª«(ᑮf⊤A1஺ghṹ&ifnotempty(thisform.textl.value)select*fromst⊤where¤¥=val(thisform.textLvalue)intocursorIsbthisform.grid1,recordsource='lsb'endif⊤ᓫDestroyṹ&useinIsb&&ᐵ®⊤ᓝ¯ஹ⚓᪾(PageFrame)1ஹ⚓᪾ḄCD•Fᵨ&v±²³⚓☢±ᡃ¶ᑖ¸^ᙢº஺⊤ᓫ”LᐹN1CD⚓᪾஺2ஹOᵨឋ,Name&⚓᪾ḄPQ•Enabled&⚓᪾Wᔲ.ᵨ•PageCount&⚓᪾1⚓☢Ḅfᦪ஺[C2஺•Pages&ᦪ_ឋPages(1)⊤⚓᪾1Ḅ»f⚓☢Pages(2)⊤⚓᪾1Ḅ»f⚓☢……•ActivePage&¼~⚓☢S஺ᡠ½¼~⚓☢ᓽ(ᙠᨬÀ☢Ḅ⚓☢஺»f⚓☢Ḅ⚓☢S1,»f⚓☢Ḅ⚓☢S2,……oÁÂ&ᙠ⊤ᓫ+qÃ⚓᪾ÄÅqÃ⚓᪾1ᔜf⚓☢ÄÅ஺⚓᪾1⚓☢ÄÅḄᨵᐵÇFÈOᵨឋÉÊ᝞&(1)᝞Ì⌱=Íf⚓☢஺(2)⚓᪾1⚓☢ÄÅḄOᵨឋ,Name&⚓☢ḄPQ,Enabled&⚓☢Wᔲ.ᵨ

68ᐰVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ,Caption&⚓☢Ḅ᪗ΕFont*&⚓☢᪗ÎḄQRஹQST,ForeColor&⚓☢᪗ÎḄU⁐Ï3᝞ÌᔣÍf⚓☢1q஺ᐜ⌱=⚓☢Òq஺Ï4Óᑏṹ⚓☢1ឋḄ⊤Ꮇ⚓᪾ḄPQyk,ᐸ1»f⚓☢ḄPQyml,»f⚓☢+ᨵfᦻ£᪾wbk,⌕⊤wbkḄValueឋ×᪵ᑏ&ThisForm.yk.yml.wbk.ValueᡈThisForm.yk.Pagesl.wbk.value3ஹOᵨ,•⚓᪾ḄOᵨ&Click&ᓫÚ⚓᪾1Û⚓☢Üt•⚓᪾1⚓☢ḄOᵨ&Click&ᓫÚ⚓☢ÜtÁÂ&᝞«ᡃ¶ÝᑏÃ⚓᪾ḄClickṹÞᑏÃ⚓᪾1⚓☢ḄClickṹᑣÍ⚓☢àᓫÚáᐜ᡻ã⚓☢ḄClickṹäåᶍ⚓᪾ḄClickṹ஺ᓝçஹèéÏSpinnerÏ⊡ᐙì1ஹèéḄCD•Fᵨ&ᦪeᜧî஺“⊤ᓫ”LᐹN1CDèé஺2ஹOᵨឋ•Name&èéḄPQ,Enabled&èéWᔲ.ᵨ•Font*&èéᑁ5ḄQRஹQST,ForeColor&èéᑁ5ḄU⁐•Increment&èéïðḄñᓄó•SpinnerHighValue&ô᪗é᦮Ḅᨬᜧe,SpinnerLowValue&ô᪗é᦮Ḅᨬîe,KeyboardHighValue&õö2ᐭḄᨬᜧe,KeyboardLowValue&õö2ᐭḄᨬîe•Value&èéḄÀe3ஹOᵨ•Click&ᓫÚèéÜt4ஹOᵨG•SetFocus&©ᯖøqᑮèé+஺

69ᐰVFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮᓝùஹúûÏImageìÏ⊡ᐙì1ஹúûḄCD•Fᵨ&ᙠ⊤ᓫ+qúû஺“⊤ᓫ”LᐹN1CDúû஺2ஹOᵨឋ•Name&úûḄPQ,Picture&ᡠ⌕(Ḅúû,Stretch&úûḄ(GH•BackStyle&úû1üᨵúûḄᙢGWᔲýÂᓝþஹᘤTimer
⊡ᐙ1ஹᘤ
Ḅ,ᵨTimer஺“⊤ᓫ
”ᐹᘤ
஺2ஹᵨឋ,NameᘤḄ"#,Enabledᘤ$ᔲ&ᵨ,IntervalḄ''◞)ᓫ*+,஺3ஹᵨ•TimerᢣḄ''◞ᑮ/4ஹᵨ0125ஹ3456)ᘤ
7&8஺6ஹ9:91ᙠ⊤ᓫ<=᝱ᙢ@A'஺92BCFACE1.ICOஹFACE2.ICOஹFACE3.ICOஹFACE4.ICOஹFACE5.ICODEFGᦻIJ=K஺LA=KḄIJ$@AMNḄFᱏᩭIJḄ஺ᓝRஹSᩩLine
⊡ᐙ1ஹSᩩ
Ḅ•ᵨᙠ⊤ᓫ

70ᐰ^_`abVFPᜓὃeᧇ2010—7-16Rebuilding᦮ᳮ9ᙠ⊤ᓫ

71ᐰ^_`abVFPᜓὃeᧇ2010—7-16Rebuilding᦮ᳮmᓫ{ᵨiஹᓫḄ1ஹᓫḄᵨᔜ¢£6ᑖ¥¦§ᙢ¨§)0©ªᵨ஺2ஹᓫḄ8¢§«¬ᓫ®¯ᣩᓫ஺I▭<)«¬ᓫ$ᵫ³´ḄᩩGᓫ®ᚖXḄ¶ᓫ·ᡂ)¹¯ᣩᓫºᵫᚖXḄ¶ᓫ·ᡂ஺3ஹᓫ⚗ᩩGᓫᡈ¶ᓫḄ¼i⚗஺4ஹᓫ⚗Ḅ½¾¿À¾ᙠᓫÁÂᩩGᓫᢥAlt¾Âஹ¶ᓫ@AᩭᓽÁÂÅ~BC¾ÆªᵨÇEᓫ⚗Ḅ¾஺ᓫ⚗)@A|È«ᑜSḄ#Êᓽ|Ëᓫ⚗ÌḄ½¾஺5ஹᓫ⚗Ḅ¯ᣩ¾ᙠᓫÍÁÂḄÎÏ«)~ªᵨÇEᓫ⚗Ḅ¾஺¯ᣩ¾B|·ᔠ¾஺6ஹᐵÒÓÔᓫªᵨ“SETSYSMENUTO”ÕÖ@AÓÔᓫªᵨ“SETSYSMENUTODEFAULTÕÖ஺aஹᓫ{×Ø1ஹVFP)Bªᵨ“ᓫ{ᘤ”ᩭ{ᓫ)ᡠ)Ú0©஺2ஹVFPᓫ{ḄiÛÜ1£ᐭᓫ{ᘤ)ᙠᓫ{ᘤ{ᓫ஺2Þß{àḄᓫ)©áÅâᦋᓫ◤⌕஺{ᘤ{àḄᓫÞßÅæçᑮi᡽é"|MNXḄᓫᦻêæë=᡽é"|MNTḄᓫᜓìᦻ)Ëᦻᡃî7Xïªᵨ஺3ᡂᓫtðᦻ஺ᡠᡂḄᓫtðᦻ᡽é"|MPRo3ஹᓫᦻ®ᓫtðᦻ•ᓫᦻ$“Cñò”)ᓫtðᦻ}$ᡃîᡠ◤⌕Ḅ“ᨬôò”஺•ᓫᦻ$ªᵨ&õᓄ“ᓫ{ᘤ”{ᓫᡠ◤⌕Ḅ஺•ᓫᦻ÷ø<$iE⊤ᦻ)ᐸúûüᡃî{Ḅᓫýþ஺•ᓫtðᦻ÷ø<$iEtðᦻ)ᐸᑁ
ᓫḄ஺᝞ᡃᓫḄᡃᓫ!ᦻ#$%◤'ᵨ“ᓫ*+ᘤ”஺4ஹᓫ!ᦻ#Ḅ/0DOᓫ!ᦻ#12ᓫ!ᦻ#Ḅ᡽45%6ḕᶍ஺᝞ḕᶍVFP
᡽45
PRGḄ!ᦻ#஺5ஹ”ᓫ*+ᘤ”Ḅ9ᐭ

72ᐰ<+=>?@VFPᜓὃCᧇ2010—7-16Rebuilding᦮ᳮ•⌱J“KL”“ᓫ”M6஺(KLᓫO'ᵨ)•⌱J“ᡭR”“ᓫ”M6஺(SᦋᓫO'ᵨ),VW2CREATEMENU2KLᓫ஺ᙠYZ[\ᓫO]^_ᓫᦻ#5`ab஺CREATEMENUᓫᦻ#2KLᓫᓫᦻ#5`abᵫde஺fᓫᦻ#Ḅ᡽45ḕᶍ஺MODIFYMENU2Sᦋᓫ஺⌕SᦋḄᓫᦻ#hij᪾f⌱J஺MODIFYMENUᓫᦻ#2SᦋᢣmḄᓫ஺fᓫᦻ#Ḅ᡽45ḕᶍ஺nஹopqᓫ*+r2*+P244r9.1ᡠ⌕tḄᓫ஺12(1)ueqᓫḄᓫ⚗wxyᑖ◞|஺ᑖ◞|VWᓫ5}
Ḅᓫ⚗Ḅ஺(2)'I⌱⚗”ᓫM62•W2ᩩᓫḄᓫ⚗*b$⌱JO᡻0W஺•ab2ᢣmᡠLᓫᓫwxḄᐵ஺
ᣚ஺•“*b”ᓫṹ2bᙠᓫ!ᦻ#wḄᑁ஺“ᳮ”ᓫṹ2bᙠᓫ!ᦻ#wḄᑁ஺(3)Iᓫ⌱⚗”ᓫM62•W2ueqᓫḄᓫ⚗*b$⌱JO᡻0W஺•5}2
ueqᓫ¡5஺¢2(1)£¤ᓫᦻ#Ḅ▭ᑁ஺(2)£¤ᓫ!ᦻ#Ḅ▭ᑁ஺(3)/0ᓫ!ᦻ#஺¦ஹ
⚔¨⊤ᓫªyᓫ1ஹ«⊤ᓫᒹᙠVFP®¯fᡠ°⚔¨⊤ᓫᓽ%VFP¯ᒹḄ⊤ᓫ-2ஹ⚔¨⊤ᓫḄ*b2⊤ᓫḄShowWindow³ឋ*
2஺3ஹ᝞µ¶opqᓫᑮ⚔¨⊤ᓫf¸•*+ᓫO“⌱⚗”fḄ“⚔¨⊤ᓫ”⌱¹஺•⊤ᓫḄInitº#f2DOᓫ!ᦻ#WITHThis,ᓫ5‘¼ᜐᓫ!ᦻ#Ḅ᡽45%ḕᶍ஺''ᓫ5"
ᩩᓫ¡5஺,⊤ᓫḄDestroyº#f2RELEASEMENUᓫ5EXTENDED¼M6
◀ᓫ஺

73ᐰ<+=>?@VFPᜓὃCᧇ2010—7-16Rebuilding᦮ᳮ4ஹr2ᐜ*+ÁÂᢥÄḄ⚔¨⊤ᓫᯠ
ᐸªyᓫ'ᐸᢥÄM6஺^21ஹᙠᓫḄᨵᐵṹfÈᵨ⊤ᓫ`ᐸÉ#Oᵨ“⊤ᓫᦻ#ÊË5”“Thisform”஺2ஹiÌḄº#ṹWÈᵨiÌḄº#ṹÍq2⊤ᓫ.iÌ.º#5஺º#5᝞“Click”Ï஺ÐஹÑᣩᓫ*+1ஹ*+⌕⚞2•LÔᓫO⌱J“Ñᣩᓫ”஺•ᙠ“ᓫ⌱⚗”f
Ñᣩᓫ¡5Õ஺•ᙠ“⌱⚗”f
“ᳮ”ᓫṹÖᐭ᝞oᑁ2RELEASEPOPUPSÑᣩᓫ5EXTENDED¼M6
◀Ñᣩᓫ஺•×Ø2ᙠᓫḄᨵᐵṹfÈᵨ⊤ᓫ`ᐸÉ#Oᵨ“⊤ᓫᦻ#ÊË5”“Thisform"஺•ᙠ◤⌕ÑᣩᓫḄiÌḄRightClickº#f᡻0ᓫ!ᦻ#஺2ஹr2P252r9.4஺¹>2¹r⚪ÚP254¹>⚪஺

74ᐰ<+=>?@VFPᜓὃCᧇ2010—7-16Rebuilding᦮ᳮYᓝÜÝ⊤*+ஹÝ⊤*+ÊẠ1ஹ+=>¹⌕ßàᡭᓺ>Ḅâ!⊤'ᵨµãᡭᓺ>஺2ஹÝ⊤ᓽÖe᱐☢Ý⊤*+ᓽÖe᱐☢Ḅ*+஺3ஹÝ⊤*+æ⌕[\[\Ý⊤¶çᑮ᡽45
FRXḄÝ⊤ᦻ#èéOêëì᡽45
FRTḄÝ⊤ᜓ×ᦻ#ᦻ#ᡃ%'ᵨí஺4ஹÝ⊤î⌕ᵨᩭÖe⊤ᡈñòfᦪôḄ஺Ý⊤ÖeᡠᵨḄ⊤ᡈñò}
Ý⊤Ḅᦪôõ஺5ஹ᝞Ý⊤ḄᦪôõömḄ¶ᐸyᐭᑮÝ⊤Ḅᦪô÷᛻fÚ᝞Ý⊤Ḅᦪôõ%ömᑣÝ⊤ᦪô÷᛻úûḄüOÈᵨÝ⊤ÖeO;þÿḄ⊤ᡈ⊤Ḅᦪ஺6ஹ⊤ᵨ“⊤ᘤ”ᓄᙢ஺7ஹ“⊤ᘤ”Ḅᐭ•⌱“”“⊤”!஺"#⊤$ᵨ%•⌱“ᡭ'”“⊤”!஺"(ᦋ#⊤$ᵨ%,+,-./CREATEREPORT⊤஺ᙠ1#234⊤$567⊤ᦻ9:;<=஺CREATEREPORT⊤ᦻ9/⊤>⊤ᦻ9:;<=ᵫ-.@A஺-.>⊤ᦻ9Ḅ᡽C:Dḕᶍ஺MODIFYREPORT(ᦋ⊤஺⌕(ᦋḄ⊤ᦻ9HIJ᪾⌱஺MODIFYREPORT⊤ᦻ9/(ᦋᢣMḄ⊤஺-.>⊤ᦻ9Ḅ᡽C:Dḕᶍ஺ᐭ“⊤ᘤ”N>⌕O3“⊤P9”QᐹSAT஺8ஹ⊤Ḅ#UVW/
1ᐭ“⊤ᘤ”஺
2⊤⚓☢=஺
3᝞[⊤Ḅᦪ\M>]ᐸ_ᐭᑮᦪa᛻஺
4᱐☢de஺
5⚜gᦔ[஺᝞[⊤ᦪa᛻iᨵᦪ>klQmn#M⌕ᨵᦪ>ᔲᑣqr⚜g஺
634⊤஺9ஹsᵨ⊤tA⚜g/REPORTFORM⊤ᦻ9NOCONSOLEPREVIEWvxyFORᩩ9y

75ᐰ|}~VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮ⚜gᦪᢣMxᑁᔠᩩ9Ḅ஺ḕᶍxᩩ9$>⚜gᦪᐰ஺-.>⊤ᦻ9᡽C:Dḕᶍ஺ᡭᓺ/REPORTFORM⊤ᦻ9NOCONSOLETOPRINTERPROMPTvxyLFORᩩ9yᡭᓺᦪᢣMxᑁᔠᩩ9Ḅ஺ḕᶍxᩩ9$>ᡭᓺᦪᐰ஺-.>⊤ᦻ9᡽C:Dḕᶍ஺ᢣM“PROMPT”$>ᡭᓺlATᡭᓺ=IJ᪾஺ஹᓫ⊤/D“⊤”ᦪ>#⊤஺1ஹ⊤•r/⚓᪗ᜮ/⚓'ᜮATḄᑁ¡஺¢⁚/⚓¤ATḄᑁ¡>¥AT#2஺⚓¦§/⚓ᨬNATḄᑁ¡஺©ªᑖ◞ᩩDs᦮®n¯ᜧ±஺᪗²P9ᵨᩭ´=\Mᑁ¡>¯P9ᵨᩭ´=⊤µ¶ᑁ¡>·ᩩP9ᵨᩭ´=¸·>¹ºP9ᵨᩭ´=¹º>ᙊ¼¹ºᵨᩭ´=ᙊ¼¹º஺⊤>P9Ḅ⌱½ஹ¾ªஹᜧ±ᦋ¿ÀÁ⊤ᓫP9>ÂÃ⊤P9DIP9ᐵ=஺•ÅÆr#Hᦪa᛻©ªÇÈᡈ⊤ᑮ⊤஺•ÅÆrᵨ“⊤ÅÆ⊤”Éᓫ஺ᵨÊr$>¢⁚n®Ë஺2ஹ+,-.sᵨ⊤tA•⚜gᡠᨵÍΕ⚜gᵱÍÎ3ஹÐÑ•ÒÓ:ᑁ¡ᙠÓ:SÔIÕ஺1ÖÅÆr>×ØÙÚÇÈÛÜᵨY⊤Ý>ᎷÜᵨN⊤Ýß1ÖÅÆr>⚓☢à᝞áâÝAḄß•ÒiᨵḄᝄäâÝËåæ⌕âÝ0஺•⊤_ç“᪗⚪”n“éê”n஺ᡠë“᪗⚪”nᓽ᦮¥⊤'ᜮᡭᓺ#2Ḅᑖíᡠë“éê”nᓽ᦮¥⊤ᨬNᡭᓺ#2Ḅᑖ஺•ᙠ⚓᪗ᜮ_ç#¥º஺

76ᐰ|}~VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮîஹᑖï⊤1:D“⊤”ᦪ>#⊤஺⌕ðᢥAòó᣸õtA>ö÷DAòóᑖï>ïḄ'øâÝ“XXXXòAḄÁ”Ç᪵஺6Ý/⊤⌕ᢥAòóú,Ñû>ö÷ÊÑûklÑû"Dᙠᦪa᛻=ORDERS%஺2/D“⊤”ᦪ>#⊤஺⌕ðᢥAòó᣸õtA>ö÷DAòóᑖï>ïḄ'øâÝ“XXXXòAḄÁ”Ç᪵஺ï>5Dឋý᣸õtA>ö÷Dឋýᑖï>ïḄ'øâÝ“X”Ç᪵஺6Ý/⊤⌕ᢥAòóឋýú,Ñû>ö÷ÊÑûklÑû஺¦þ/"1%ÿᑖ⌕᜜☢Ḅ☢Ḅ஺2⌕Ḅᑖᑤ◀஺ஹᑖ⊤“!"#$%⊤”'ᦪ)*+⊤஺⌕,-!./01ஹ23ஹឋ56⚗89஺:;1<=᪵/0Ḅ?@ABC2᝞EFGCᑖ/03ᑖ/0HIJKABL⚪CH☢Nᨵ⊤ᜮ஺QஹR/01“!⊤”'ᦪ)*+⊤஺⌕,STU!89V⌕WTUXYᦪஹZᙳ\]ஹᨬᜧ\]ஹᨬ`\]஺2“a▅⊤”'ᦪ)*+⊤஺⌕,c+!Ḅa▅89TUᙠ+efR-!Ḅag#ᦪ஺hஹᑭᵨ⊤ᔣlmn⊤opo⚪஺

77ᐰstpuVFPᜓὃxᧇ2010—7-16Rebuilding᦮ᳮ|ᓝ+~ᦪ)ᵨRḄJ+ஹᦪ)ᵨRᭆᦪ)ᵨRᢣᑭᵨᦪ)ᳮR᝞VFP<ḄW᪀nḄᦪ)ᜐᳮḄᵨR஺ᵫᦪ)ᵨRḄᓫஹ⊤ᓫᦪ)ᡠᦪ)ᳮR᝞VFP<+ḄYWᦪ)ᵨRᦪ)஺ᙠtpᵨ¡¢Ḅ£ᜩᦪ)ᵨR¥ᜐᙠ᝞¦gᳮRஹ§¨ᳮRஹ©ª¨ᜐᳮR஺uஹᦪ)ᵨRḄᡂ1ஹ¬ᦻ®ᡂḄ¯°±ᑭᵨVFPJḄᦪ)ᵨR+²ᒹ´µᑡᦻ®•ᦪ)¢⊤ᦻ®•⊤ᓫᦻ®•⊤ᦻ®•ᓫᦻ®ஹᓫ¸¹ᦻ®•º¸¹ᦻ®»¼ºᦻ®<•ᐸ¾ᦻ®᝞¿Àᦻ®¦Áᦻ®<2ஹ'ÂÃᦻ®ḄÄᵨᦪ)ᵨRḄᦻ®ÅÆÇᑮÉÊË¢ᐸÌÊËÍÆfÎÏÊË'ÐÊË஺=᪵¸¹ÑṹÆÄᵨÐÊËÆḄᦻ®ÓÔÕᑏᦻ®3ÄᵨÐÊËÌÊËÆḄᦻ®=᪵ᑏÓÌÊË3'ᦻ®3ØÌÊË3'ÌÊË3'ᦻ®3Ø……஺=᪵ÚḄÛᜐÍᦪ)ᵨRᡠᙠÊË¢ᐸÌÊËÜÝÞß.⌕àáÎᐸᡠᙠÊË'ÐÊËᑣ¸¹ÑṹÆÄᵨᦻ®ḄÜÝãᵨÄ᦮஺3ஹºᦻ®Ḅᵨ¢ᡂ•ᑭᵨVFPJᦪ)ᵨRäåᨵ+ºᦻ®஺ᦪ)ᵨR¬ºᦻ®æç஺•ºᦻ®ḄᵨèæÝI¼èæᓄê᛻<ØÄᵨᓫᡈ⊤ᓫØíᵨᡝØឮðÝ⌕<஺,ºᦻ®ᡂU***èæÝsettalkoffsetescapeoffsetstatusbaroff

78ᐰstpuVFPᜓὃxᧇ2010—7-16Rebuilding᦮ᳮsetdeletedoff&&TU᪗õõËsetexactoffsetsysformatsoffsetcenturyon&&Ü\setdatetoansi&&ö÷yyyy.mm.ddsetnearoff&&seekøùḄú;ᡂõËᢣ┐ᢣᔣᨬüýḄõËsetsafetyoff&&ᐵÿᐰsethoursto24&&24ᑴsetsysmenuoff&&ᐵᓫ***uzoomwindowsscreenmaxmodifywindowscreen;titleᡂᳮnozoom;nogrow;noclose;fillfilebackgrnd.jpgzx=.t.&&├᝱domenu.mpr&&!ᵨᓫ#$ᦻ&readevents&&'(ᵨᡝ*+,-./&012•45᝞789:;Ḅ+=ᦻ&Ḅ>?@Aᙠ''⌱⚗”GH᪾JKL@ᢥNShiROᓫP“RS”@ᑣ:;ḄUVWWJKᙠUVX,Zᑴ[\@]^ᑮᦻ&`ᓽA,bᑁdAᑤᣵ2஺hஹᦪklmᵨᦻ&Ḅno1ஹWpᦪklmᵨᡠrsᑮḄᔜuᦻ&vwxyz@ᱯ|}G~ᜧZᩖḄᦪklmᵨ}᝞஺=~Gᦻ&Ḅno@VFP+“⚗ᳮᘤ”Ḅᐹ@v[@A9wᙢJnᡂᦪklmᵨḄᔜuᦻ&஺2ஹ᝞ᑭᵨ“⚗ᳮᘤ”noᳮᦪklmᵨᦻ&Wᙠᦪklmᵨ>ᵨ“⚗ᳮᘤ”12⌱“-”“⚗”¡¢஺£Ḅ⚗A9ᳮ¤=ᦪklmᵨ஺,2=-Ḅ⚗¥Wpᦻ&¦§ᢣS©ª«஺¬ᑮWp᡽¯¦=PJXḄ⚗ᦻ&,°±²³Wp᡽¯¦=PJTḄ⚗ᜓᦻ&2஺⚗ᦻ&`@µ¶nᡂᦪklmᵨḄᦻ&·¸஺3¹ᐭᑮ“⚗ᳮᘤ”஺ᦪklmᵨḄW»ᦻ&x¼“⚗ᳮᘤ”`-.஺=Wpᦪklmᵨ-.Wp⚗ᦻ&L@½L¾⌕ᡭÁ⚗ᦻ&@

79ᐰÃÄÅÆÇÈVFPᜓὃÊᧇ2010—7-16Rebuilding᦮ᳮ¢¹ᐭᑮÁᦪklmᵨḄ“⚗ᳮᘤ”஺Çᙠᦪklmᵨ9LÍᵨ“⚗ᳮᘤ”,12-W⚗஺
2ᙠ“⚗ᳮᘤ”`@ᵨ“ÎÏ”¡¢ÏᐭÐÑÒḄᔜuᦻ&஺3ஹ“⚗ᳮᘤ”Ḅ¹ᐭÓ•⌱“-”“⚗”¡¢஺,-W⚗ᵨ2•⌱“ᡭ”“⚗”¡¢஺,ÔÕW⚗ᵨ2,vUVCREATEPROJECT-⚗஺⚗ᦻ&¦s«ᙠGH᪾`ÖJ஺CREATEPROJECT⚗ᦻ&-⚗@⚗ᦻ&¦s«ᵫUVÖJ஺UV`@⚗ᦻ&Ḅ᡽¯¦A9ḕᶍ஺MODIFYPROJECTÔÕÚp⚗஺⚗ᦻ&¦s«ᙠGH᪾`ÖJ஺MODIFYPROJECT⚗ᦻ&ÔÕᢣSḄ⚗஺UV`@⚗ᦻ&Ḅ᡽¯¦A9ḕᶍ஺ÛஹÜÝᦪklmᵨ1ஹᦪklmᵨrsᑮḄᦻ&W»xwz@Þ߬ᦻ&àᵨᡝᵨ@ᨵ᝞âãzäå•ᦻ&æz@d᧕èᜫ஺•êëᙠVFP1᛻âíî@íîïð᠒஺ò#$'ó⁚Wõö÷@øᑭùú³ᩗüý஺2ஹÜÝᦪklmᵨᢣ¬ᦪklmᵨᡠrsᑮḄᦻ&ᔠ§ᑮWÿᡂ᡻ᐸᑁḄᦻ஺ᯠ᪵஺3ஹ!ᦪ#$%ᵨ'()*ᙠ“⚗./ᳮᘤ”34஺4ஹ!ᦪ#$%ᵨ'(Ḅ5678
1ᦪ#$%ᵨ'(ᡠ:;ᑮḄᦻ3=ᑁ>Ḅᦻ“ᒹ@”4ᩭ=ᑁBᦋ>Ḅᦻ“᣸◀”ᣵGHIJ''⚗./ᳮᘤ”3LMN஺5OPQᦪ#$;⊤ᦻS⌕“᣸◀”ᣵ஺ᦻᒹ@;᣸◀UVW஺
2XYZᦻ஺XY[\UVW஺
3XYᐸ]⚗.^_᝞ᦪ#$%ᵨ'(Ḅa᪗c஺XY[\UVW஺
4d⚗.஺defUVW஺*ᵨd⌱⚗@h8•d%ᵨkl8mᡂ᡽opqAPPḄ%ᵨklᦻrᦻsᙠVFPt᛻Qv஺•d᡻ᦻ8mᡂ᡽opqEXEḄ᡻ᦻrᦻῃx

80ᐰz{|}~VFPᜓὃᧇ2010—7-16Rebuilding᦮ᳮVFPt᛻v◤⌕VFPḄvfp6r.dllvfp6enu.dllᢝ஺VFPḄ}ᘤ3Bᨵᦻ஺•!ᐰᦻ8⌱3ᦪ#$%ᵨ'(ᡠᒹ@Ḅᦻᐰ!⌱ᦋḄᦻ4!஺•W┯^_8⌱3!k3Ḅ┯^_=ᑮ᡽opqERRḄᦻ3rᦻḄp¡⚗.ᦻ஺¢ὃ8!£Ḅᦪ#$%ᵨ'(ᒹ¤¥¦ᦻ§A᡽opqAPPḄ%ᵨklᦻᡈ᡽opqEXEḄ᡻ᦻ஺B᡽opqAPPḄ%ᵨklᦻᡈ᡽opqEXEḄ᡻ᦻᦪ#$%ᵨ'(ᒹ@Ḅᦻ஺C᡽opqAPPḄ%ᵨklᦻᡈ᡽opqEXEḄ᡻ᦻᦪ#$%ᵨ'(᣸◀Ḅᦻ஺DS஺5ஹ᡽opqAPPḄ%ᵨklᦻᡈ᡽opqEXEḄ᡻ᦻḄv஺©ஹᦪ#$%ᵨ'(ª«}8¬⚗.=Ḅ®ᐵᦻ°ᐭᑮ⚗.3²³Zᦻᨬ£dmᡂ᡻ᦻv᡻ᦻ஺