2008-2009-vfp_a(±¾)(²×²¨Ô°)

A. Backup\\

B. (\\

35£®ÓÐÒ»¸ö²Ëµ¥Îļþmm.mnx£¬ÒªÔËÐиò˵¥µÄ·½·¨ÊÇ£¨ £©¡£

A. Ö´ÐÐÃüÁîDO mm.mnx B. Ö´ÐÐÃüÁîDO MENU mm.mnx

C. ÏÈÉú³É²Ëµ¥³ÌÐòÎļþmm.mpr£¬ÔÙÖ´ÐÐÃüÁîDO mm.mpr D. ÏÈÉú³É²Ëµ¥³ÌÐòÎļþmm.mpr£¬ÔÙÖ´ÐÐÃüÁîDO MENU mm.mpr ¶þ¡¢Ìî¿ÕÌ⣨¹²20¿Õ£¬Ã¿¿Õ1·Ö£¬¹²¼Æ20·Ö£©

±¾Ìâ µÃ·Ö 1£®Visual FoxProϵͳ֧³Ö3ÖÖ²»Í¬µÄË÷ÒýÎļþ£¬¼´ ½á¹¹¸´ºÏ Ë÷ÒýÎļþ¡¢·Ç½á¹¹¸´ºÏË÷ÒýÎļþºÍ¶ÀÁ¢Ë÷ÒýÎļþ¡£

2£®º¯ÊýLEN£¨SPACE£¨3£©?SPACE£¨2£©£©µÄ½á¹ûÊÇ__5________¡£

3£®ÔÚÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼ÆÖУ¬Í¨¹ýÀà¿ÉÒÔ¼ò»¯Ó¦ÓóÌÐòµÄÉè¼Æ£¬ÒòΪÀà¾ßÓÐ ¼Ì³ÐÐÔ ¡¢¶à̬ÐÔ¡¢·â×°ÐÔ¡¢³éÏóÐÔµÈÌØµã¡£

4£®ÊµÏÖÈËÐÔ»¯¹ÜÀí£¬ÔÚÿ¸öÔ±¹¤ÉúÈյĵ±ÈÕ»áÔùËÍÀñÆ·¡£ÆäÈËʵµ°¸±íÖаüº¬Ò»¸ö³öÉúÈÕÆÚ×ֶΣ¨×Ö¶ÎÃûΪcsrq£¬ÀàÐÍΪÈÕÆÚÐÍ£©£¬Ôò¸ù¾Ý¡°ÔÂÈÕ¡±£¨²»°üº¬¡°Äê·Ý¡±£©´´½¨Ë÷Òýʱ£¬ÆäË÷Òý±í´ïʽ¿ÉÒÔΪ Right(DTOC(csrq, 1) , 4)¡£

5£®ÔÚĬÈÏÇé¿öÏ£¬º¯ÊýLEN(STR(123456789012))µÄ·µ»ØÖµÎª 10 £¬º¯ÊýLEN(DTOC(DATE()))µÄ·µ»ØÖµÎª 8 ¡£

6£®SQLÓïÑÔÊǹØÏµÐÍÊý¾Ý¿âµÄ±ê×¼²éѯÓïÑÔ¡£ÔÚVFPÖУ¬Ê¹ÓÃSELECT-SQL½øÐÐÊý¾Ý²éѯʱ£¬Èç¹ûÒªÇóÔÚ²éѯ½á¹ûÖÐÎÞÖØ¸´¼Ç¼£¬Ôò±ØÐëÔÚÃüÁîÖÐʹÓà Dist___________¶ÌÓ×Ó¾ä/¹Ø¼ü´Ê£©¡£ 7£®Çå³ýÖ÷´°¿ÚÆÁÄ»µÄÃüÁîÊÇ______Clear__________ ¡£

8£®ÏÂÁгÌÐò¶ÎÓÃÒ»¾äÃüÁî¿É±íʾΪ____Y=iif(X>=85,¡±ÓÅÐ㡱,iif(X>=60,¡±ºÏ¸ñ¡±,¡±²»ºÏ¸ñ¡±))_________________¡£

DO CASE

CASE x>=85

Y=¡±ÓÅÐ㡱

CASE x>=60 Y=¡±ºÏ¸ñ¡± OTHERWISE Y=¡±²»ºÏ¸ñ¡±

5

ENDCASE

9£®ÔÚVisual FoxProÖУ¬ÔËÐÐ±íµ¥Ê±×îÏÈ´¥·¢µÄ±íµ¥Ê¼þÊÇ___Load________ʼþ¡£

10£®ÒªÎª±íµ¥Éè¼ÆÏÂÁÐÀ­Ê½²Ëµ¥£¬Ê×ÏÈÐèÒªÔڲ˵¥Éè¼ÆÊ±£¬ÔÚ¡°³£¹æÑ¡Ï¶Ô»°¿òÖÐÑ¡Ôñ¡°¶¥²ã±íµ¥¡±¸´Ñ¡¿ò£»Æä´ÎÒª½«±íµ¥µÄShowWindowÊôÐÔÖµÉèÖÃΪ__×÷Ϊ¶¥²ã±íµ¥_____£¬Ê¹Æä³ÉΪ¶¥²ã±íµ¥£»×îºóÐèÒªÔÚ±íµ¥µÄ__init______ʼþ´úÂëÖÐÌí¼Óµ÷Óò˵¥³ÌÐòµÄÃüÁî¡£

11£®ÒÑÖª¿Î³Ì£¨KC£©±íÖк¬¿Î³Ì´úºÅ(kcdh)¡¢¿Î³ÌÃû£¨kcmm£©µÈ×ֶΣ¬³É¼¨(CJ)±íÖк¬¿Î³Ì´úºÅ(kcdh)¡¢³É¼¨(cj)µÈ×ֶΡ£ÍêÉÆÏÂÁÐSQLÃüÁîÒÔ²éѯÿÃſεÄÑ¡¿ÎÈËÊý¡¢ÓÅÐãÈËÊý¡¢²»¼°¸ñÈËÊý¡£ SELECT Kc.kcdh, Kc.kcm, Count(*) AS Ñ¡¿ÎÈËÊý,;

SUM(IIF(cj.cj>=90,1,0)) AS ÓÅÐãÈËÊý, ; SUM(IIF(cj.cj<60,1,0)) AS ²»¼°¸ñÈËÊý; FROM sjk!kc INNER JOIN sjk!cj ; ON Kc.kcdh = Cj.kcdh; GROUP BY 1

12£®ÒÑ֪ijÊý¾Ý¿â±íKCYZ.DBFº¬ÓÐ5¸ö×ֶΣ¬ÈôÆäÖÐÓÐÒ»¸öÃûΪbxkµÄÂß¼­ÐÍ×ֶΣ¬Ôò¿ÉÓÃÏÂÁÐSQLÃüÁî²éѯbxk×Ö¶ÎֵΪ.T.µÄËùÓмǼ£¬ÇÒÒªÇóÊä³öËùÓÐ×ֶΣ¬Êä³ö½á¹û±£´æÔÚ±íTEMP.DBFÖС£

SELECT * FROM kcyz; WHERE bxk=.T.;

Into Table temp

13£®ÉèLabel1ÊÇij±íµ¥ÉÏÒ»¸ö±êÇ©¿Ø¼þ£¬ÓÃÀ´ÏÔʾϵͳÈÕÆÚºÍʱ¼ä£¬Ôò¿ÉÒÔÔÚ±íµ¥µÄInitʼþÖбàд´úÂëThisForm.Label1.Caption

_ =TTOC£¨datetime( )£©¡£

14£®Ê¹ÓÃLOCAL¡¢PRIVATEºÍPUBLICÃüÁî¿ÉÒÔÖ¸¶¨ÄÚ´æ±äÁ¿µÄ×÷ÓÃÓò¡£ÔÚVFPÃüÁî´°¿ÚÖд´½¨µÄÈκÎÄÚ´æ±äÁ¿¾ùΪ ¹«¹²±äÁ¿ ¡£

15£®Ò³¿ò¿Ø¼þÊǰüº¬Ò³ÃæµÄÈÝÆ÷¶ÔÏó¡£ÔÚĬÈÏÇé¿öÏ£¬Ò³¿ò¿Ø¼þ°üº¬2¸öÒ³Ãæ£¬Èç¹ûÒªÐÞ¸ÄÒ³ÃæÊý£¬ÔòÓ¦¸ÃÉèÖã¨Ð޸ģ© PAGECOUNT ÊôÐÔ¡£

16£®½«²Ëµ¥ÉèÖÃΪVFPϵͳĬÈϲ˵¥µÄÃüÁîÊÇSET SYSM TO DEFAULT¡£

±¾Ìâ µÃ·Ö Èý¡¢¸ù¾ÝÒªÇó±àдSQLÓï¾ä£¨¹²5СÌ⣬ÿÌâ3·Ö£¬¹²¼Æ15·Ö£©

ÒÑÖª£º £¨1£©Ñ§Éú±íXS.DBF °üº¬×Ö¶ÎXH£¬XM£¬XB£¬XDH£¬XIMING·Ö±ð±íʾѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢ÐÔ±ð¡¢Ïµ´úºÅºÍϵÃû¡£

£¨2£©¿Î³Ì±íKC.DBF°üº¬×Ö¶ÎKCDH£¬KCM£¬KSS£¬BXK£¬XF·Ö±ð±íʾ¿Î³ÌµÄ¿Î³Ì´úºÅ¡¢¿Î³ÌÃû¡¢¿ÎʱÊý¡¢ÊÇ·ñ±ØÐ޿Ρ¢Ñ§·Ö¡£

£¨3£©³É¼¨±íCJ.DBF°üº¬×Ö¶ÎXH£¬KCDH£¬CJ·Ö±ð±íʾѧºÅ¡¢¿Î³Ì´úºÅºÍ³É¼¨¡£

6

£¨4£©¹¤×ʱíGZ.DBF°üº¬×Ö¶ÎGH£¬JBGZ·Ö±ð±íʾ¹¤ºÅºÍ»ù±¾¹¤×Ê¡£

£¨5£©Ñ§Éú±íÓë³É¼¨±íÒѰ´ÕÕXH½¨Á¢ÓÀ¾Ã¹ØÏµ£¬¿Î³Ì±íÓë³É¼¨±í°´ÕÕKCDH ½¨Á¢ÓÀ¾Ã¹ØÏµ¡£ 1£®½«¿Î³Ì±íÖÐËùÓеıØÐ޿ογÌÔö¼Ó1¸öѧ·Ö¡£

2£®Ð޸Ť×ʱí½á¹¹£¬Ôö¼ÓÒ»ÁÐXM£¬×Ö·ûÐÍ¡¢³¤¶ÈΪ10¡¢²»ÔÊÐíΪ¿Õ¡£

3£®»ùÓÚѧÉú±í²éѯ¸÷ϵÈËÊý£¬ÒªÇóÊä³öϵÃûºÍÈËÊý£¬½á¹û°´ÈËÊý½µÐòÅÅÁС£

4£®»ùÓڿγ̱íºÍ³É¼¨±í²éѯ¸÷Ãſγ̵Ä×î¸ß·Ö£¬ÒªÇóÊä³öKCDH¡¢KCMºÍ×î¸ß·Ö¡£

5£®»ùÓÚѧÉú±íºÍ³É¼¨±í²éѯ¡°06¡±Äê¼¶ÓÅÐãÉúµÄÐÅÏ¢£¬ÒªÇóÊä³öµÄ×Ö¶ÎΪ£ºÑ§ÉúµÄxh¡¢xm¡¢Æ½¾ù·Ö¡¢×îµÍ·Ö£¬Êä³ö½á¹û°´ÓÅÐãÉúƽ¾ù·ÖµÄ½µÐòÅÅÐò¡£

£¨×¢£ºxh×ֶεÄǰÁ½Î»±íʾÄê¼¶£»ÓÅÐãÉúµÄÌõ¼þÊǸ÷ÃÅ¿ÎµÄÆ½¾ù·Ö²»µÍÓÚ85ÇÒÿÃſεijɼ¨²»µÍÓÚ75¡££©

±¾Ìâ

µÃ·Ö ËÄ¡¢ÍêÉÆ³ÌÐòÌ⣨¹²5СÌ⣬ÿ¿Õ1·Ö£¬¹²¼Æ8·Ö£©

1£®ÏÂÃæ³ÌÐòÊÇÇó1µ½100Ö®¼äµÄżÊýºÍ²¢Êä³ö¡£

I=1 S=0

&&S´æ·ÅżÊýµÄÀÛ¼ÓºÍ

DO WHILE I<=100

IF I%2=___0__________ &&ÅжÏIÊÇ·ñΪżÊý

S=S+I

ENDIF

__I=I+1_________________

ENDDO ??S=? ,S

2£®ÏÂÁгÌÐò¿É½«ÓÉÈÎÒâ×Ö·û£¨°üÀ¨ºº×Ö£©×é³ÉµÄ×Ö·û´®½øÐз´ÐòÏÔʾ¡£³ÌÐòÇåµ¥ÈçÏ£º

STORE ?ABCDEF? TO c,cc p=SPACE(0)

DO WHILE LEN(c)>0 x=ASC(LEFT(c,1)) IF x>127

7

i=2

ELSE

i= 1 ___

ENDIF

p= Left(C,i) +p c=SUBSTR(c,i+1) ENDDO

3£®ÏÂÃæ³ÌÐò¼ÆËãÒ»¸öÕûÊýµÄ¸÷λÊý×ÖÖ®ºÍ£º

SET TALK OFF INPUT ¡±x=¡± TO x s=0

DO WHILE x£¡=0 s=s+MOD£¨x,10£© x=INT(_X/10_________) ENDDO ?s

SET TALK ON

4£®×Ô¶¨Ò庯Êýccdow()µÄ¹¦ÄÜΪ£º¸ù¾ÝÒ»¸öÈÕÆÚÖµ·µ»ØÓúº×Ö±íʾµÄÐÇÆÚ¡£ÀýÈçccdow({^1999-03-01})µÄ·µ»ØÖµÎª¡°ÐÇÆÚÒ»¡±¡£

Function ccdow Para date1 N=dow(date1) S=¡±ÌìÒ»¶þÈýËÄÎåÁù¡±

Return ¡°ÐÇÆÚ¡±+___SUBSTR(S,2*N-1,2)______________ EndFunc

5£®ÔËÐÐXY.PRG³ÌÐòºó£¬½«ÔÚÆÁÄ»ÉÏÏÔʾÈçϳ˷¨±í£º

(1) 1 (2) 2 4 (3) 3 6 9 (4) 4 8 12 16 (5) 5 10 15 20 25 (6) 6 12 18 24 30 36 (7) 7 14 21 28 35 42 49

8

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)