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