VFPϰÌâÒÔ¼°SQLÁ·Ï°Ìâ

1 990001 ÍõÏþ¶« ÄÐ 10/03/80 Ó¦ÓÃÊýѧ Êé·¨ ÍÅÔ± 2 990002 Àî×ÓÇå ÄÐ 05/12/79 Ó¦ÓÃÊýѧ Ô˶¯ µ³Ô± 3 990003 ÕÔС·¼ Å® 02/16/80 Ó¦ÓÃÊýѧ Î赸 ÍÅÔ± 4 990004 ºÎèë¾ý Å® 08/04/80 Ó¦ÓÃÊýѧ Êé·¨ ÍÅÔ± 5 990101 Фͤͤ Å® 10/23/80 ¼ÆËã»úÓ¦Óà »æ»­ µ³Ô± 6 990102 »ô´óΰ ÄÐ 02/11/79 ¼ÆËã»úÓ¦Óà Ô˶¯ ÍÅÔ± 7 990104 ÂíÑÞ·ã Å® 06/12/81 ¼ÆËã»úÓ¦Óà Î赸 ÍÅÔ±

8 990103 ÇúÀö·¼ Å® 03/03/78 ¼ÆËã»úÓ¦Óà ÉãÓ° ÍÅÔ±

CLEA USE STUD

SCAN FOR ÐÔ±ð=\ÄÐ\ ?RECNO(),±àºÅ ENDSCAN USE RETU

Êä³ö½á¹ûΪ£º ¡£ 5. ³ÌÐòÈçÏ£º SET TALK OFF CLEAR X=1 S=0

DO WHILE X<3 S=S+LC(X) X=X+1 ENDDO ? S

SET TALK ON RETURN

FUNCTION LC PARAMETERS P P=P+1

RETURN P*P

³ÌÐòÔËÐкó£¬SµÄÖµÊÇ ¡£

VFP6.0µ¥ÔªÁ·Ï°£¨Ò»£©

Ò»¡¢µ¥ÏîÑ¡ÔñÌâ

1¡¢Êý¾Ý¿â¹ÜÀíϵͳµÄÓ¢ÎÄËõдÊÇ£¨ £©¡£ A¡¢DB B¡¢DBS C¡¢DBMS D¡¢DBA 2¡¢Êý¾Ý¿âϵͳµÄºËÐIJ¿·ÖÊÇ£¨ £©¡£

A¡¢Êý¾ÝÄ£ÐÍ B¡¢Êý¾Ý¿â C¡¢¼ÆËã»úÓ²¼þ D¡¢Êý¾Ý¿â¹ÜÀíϵͳ 3¡¢ÔÚ¹ØÏµÐ͵ÄÊý¾Ý¿â¹ÜÀíϵͳÖУ¬ÈýÖÖ»ù±¾¹ØÏµÔËËãÊÇ£¨ £©¡£ A¡¢Ñ¡Ôñ¡¢Í¶Ó°ºÍÁ¬½Ó B¡¢Ñ¡Ôñ¡¢É¾³ýºÍ¸´ÖÆ C¡¢´´½¨¡¢Ð޸ĺͺϲ¢ D¡¢Í³¼Æ¡¢Á¬½ÓºÍ·ÖÀà

4¡¢Êý¾Ý¿âÎļþµÄÀ©Õ¹ÃûÊÇ_____¡£

A¡¢.IDX B¡¢.DBF C¡¢ .PJX D¡¢ .DBC 5¡¢VFP6.0ÊÇÒ»ÖÖ£¨ £©Êý¾Ý¿â¹ÜÀíϵͳ¡£

A¡¢²ã´ÎÐÍ B¡¢Íø×´ÐÍ C¡¢¹ØÏµÐÍ D¡¢Âß¼­ÐÍ 6¡¢²»Êǰ²È«¿É¿¿µØÍ˳öVFP6.0ϵͳµÄÕýÈ··½·¨ÊÇ£¨ £©¡£ A¡¢ÔÚÃüÁî´°¿ÚÖ´ÐÐQUITÃüÁî B¡¢Á¢¼´¹Øµô¼ÆËã»úµçÔ´ C¡¢µ¥»÷´°¿ÚÓÒÉÏ·½µÄ ¡°X¡± D¡¢°´ALT+F4×éºÏ¼ü

7¡¢¶ÔVFP6.0µÄÔËÐл·¾³½øÐж¨ÒåºÍµ÷ÕûµÄĬÈÏÅäÖÃÎļþÊÇ£¨ £©¡£ A¡¢CONFIG.FPW B¡¢AUTOEXEC.BAT C¡¢CONFIG.SYS D¡¢FOXPLUS.DBF 8¡¢VFP6.0ÔÊÐí×î¶à¿ÉʹÓ㨠£©¸öÄÚ´æ±äÁ¿¡£ A¡¢3600 B¡¢65000 C¡¢256 D¡¢512 9¡¢ÔÚVFP6.0ÖпÉÒÔʹÓõij£Á¿ÀàÐÍÓУ¨ £©¡£ A¡¢ÊýÖµÐÍ¡¢×Ö·ûÐÍ¡¢ÈÕÆÚÐÍ¡¢Í¨ÓÃÐÍ¡¢±¸×¢ÐÍ B¡¢ÊýÖµÐÍ¡¢×Ö·ûÐÍ¡¢ÈÕÆÚÐÍ¡¢Âß¼­ÐÍ¡¢±¸×¢ÐÍ C¡¢ÊýÖµÐÍ¡¢×Ö·ûÐÍ¡¢ÈÕÆÚÐÍ¡¢Âß¼­ÐÍ D¡¢ÊýÖµÐÍ¡¢×Ö·ûÐÍ¡¢±¸×¢ÐÍ 10¡¢ÏÂÁÐÕýÈ·µÄ×Ö·ûÐͳ£ÊýÊÇ£¨ £©¡£

A¡¢\ B¡¢\C¡¢\ D¡¢\11¡¢¹ØÓÚ¿Õ×Ö·û´®µÄÕýȷ˵·¨ÊÇ£¨ £©¡£

A¡¢¶¨½ç·ûÄÚÖ»°üº¬Óпոñ B¡¢¶¨½ç·ûÄÚÖ»°üº¬ÓÐÒ»¸ö¿Õ¸ñ

C¡¢¿Õ×Ö·û´®µÄ³¤¶ÈΪ0 D¡¢¿Õ×Ö·û´®µÄ³¤¶ÈÈ¡¾öÓÚ¶¨½ç·ûÄÚ¿Õ¸ñµÄ¸öÊý 12¡¢ÔÚÒ»¸ö×Ö·û´®ÖУ¬×î¶à¿É°üº¬£¨ £©¸ö×Ö·û¡£ A¡¢80 B¡¢254 C¡¢256 D¡¢120 13¡¢ÔÚÒ»¸ö×Ö·û´®ÖУ¬×î¶à¿ÉʹÓ㨠£©¸öºº×Ö¡£ A¡¢80 B¡¢254 C¡¢256 D¡¢127

14¡¢ÈÕÆÚÐͳ£ÊýÊÇÓÃÀ´±íʾÈÕÆÚµÄÒ»ÖÖÌØÊâÊý¾Ý£¬Æä³¤¶ÈΪ£¨ £©¸ö×Ö½Ú¡£ A¡¢ÈÎÒâ B¡¢10 C¡¢6 D¡¢8

15¡¢VFP6.0ÓÐÁ½ÖÖÐÔÖʵıäÁ¿£¬¼´£¨ £©¡£

A¡¢ÊýÖµÐͱäÁ¿ºÍ×Ö·ûÐͱäÁ¿ B¡¢ÄÚ´æ±äÁ¿ºÍ×ֶαäÁ¿ C¡¢¾Ö²¿±äÁ¿ºÍÈ«¾Ö±äÁ¿ D¡¢¼òµ¥±äÁ¿ºÍÊý×é±äÁ¿

16¡¢ÔÚÏÂÁÐ×Ö·û´®ÖУ¬²»·ûºÏVFP6.0¹æ¶¨µÄ·Ç·¨±äÁ¿ÃûÊÇ£¨ £©¡£ A¡¢GZINPUT2 B¡¢A_SK97 C¡¢4AK D¡¢ÐÕÃû

17¡¢ÔÚÏÂÁÐ×Ö·û´®ÖУ¬·ûºÏVFP6.0¹æ¶¨µÄÕýÈ·±äÁ¿ÃûÊÇ£¨ £©¡£ A¡¢FE_1234 B¡¢LIST C¡¢25ABCD D¡¢PS:12

18¡¢ÒѾ­¶¨ÒåÁËÒ»¸öһάÊý×éA(6)£¬²¢ÇÒA(1)µ½A(4)¸÷Êý×éÔªËØµÄÖµÒÀ´ÎÊÇ£º1£¬3£¬5£¬2¡£È»ºóÓÖ¶¨ÒåÁËÒ»¸ö¶þάÊý×éA(2,3)£¬Ö´ÐÐÃüÁî?A(2,2)ºó£¬ÏÔʾµÄ½á¹ûÊÇ_____¡£ A¡¢ÏÔʾ±äÁ¿Î´¶¨ÒåµÄÌáʾ B¡¢4 C¡¢2 D¡¢.F. 19¡¢VFP6.0¹æ¶¨Ä¬ÈÏÄÚ´æ±äÁ¿µÄ¸öÊýΪ£¨ £©¸ö¡£ A¡¢1200 B¡¢3600 C¡¢1024 D¡¢10000

20¡¢ÉèXµÄֵΪ4£¬Ö´ÐУ¿X=X+1ÃüÁîºóµÄ½á¹ûÊÇ£¨£©¡£ A¡¢4 B¡¢5 C¡¢.T. D¡¢.F.

21¡¢µ±ÄÚ´æ±äÁ¿Óë×ֶαäÁ¿Í¬Ãûʱ£¬ÏµÍ³ÓÅÏȵذ´£¨ £©¶Ô´ý¡£

A¡¢×ֶαäÁ¿ B¡¢ÄÚ´æ±äÁ¿ C¡¢¾Ö²¿±äÁ¿ D¡¢È«¾Ö±äÁ¿

22¡¢Èç¹ûÄÚ´æ±äÁ¿Óë×ֶαäÁ¿Í¬Ãûʱ£¬¿ÉÒÔÔÚÄÚ´æ±äÁ¿Ç°Ãæ¼ÓÉϱêÖ¾£¨ £©À´Ìرð˵Ã÷¸Ã±äÁ¿ÊÇÄÚ´æ±äÁ¿¡£ A¡¢A. B¡¢M. C¡¢B. D¡¢G.

23¡¢ÔÚVFP6.0ÖУ¬¿ÉÒÔʹÓÃËÄÖÖÀàÐ͵ıí´ïʽ£¬ËüÃÇÊÇ£¨ £©¡£

A¡¢ÊýÖµÐÍ¡¢×Ö·ûÐÍ¡¢ÈÕÆÚÐÍ¡¢Í¨ÓÃÐÍ B¡¢±¸×¢ÐÍ¡¢×Ö·ûÐÍ¡¢Âß¼­ÐÍ¡¢ÊýÖµÐÍ C¡¢ÊýÖµÐÍ¡¢×Ö·ûÐÍ¡¢ÈÕÆÚÐÍ¡¢±¸×¢ÐÍ D¡¢ÊýÖµÐÍ¡¢×Ö·ûÐÍ¡¢ÈÕÆÚÐÍ¡¢Âß¼­ÐÍ 24¡¢¹ØÓÚ¹ØÏµ±í´ïʽÔËËãµÄÕýȷ˵·¨ÊÇ£¨ £©¡£ A¡¢¹ØÏµÔËËã·ûÁ½±ßµÄ±í´ïʽµÄÀàÐÍ¿ÉÒÔ²»Ò»Ö B¡¢¹ØÏµ±í´ïʽÔËËãµÄ½á¹û²»ÊÇÂß¼­Öµ

C¡¢¹ØÏµÔËËã·ûÔÚÔËËã˳ÐòÉÏûÓÐÓÅÏÈÖ®·Ö£¬×ÜÊÇÏȵ½ÏÈËã D¡¢¹ØÏµÔËËã·ûÖ»ÄܶÔ×Ö·û´®½øÐбȽÏ

25¡¢Âß¼­ÔËËã·û´Ó¸ßµ½µÍµÄÔËËãÓÅÏȼ¶ÊÇ£¨ £©¡£ A¡¢.NOT. .OR. .AND. B¡¢.NOT. .AND. .OR. C¡¢.AND. .NOT. .OR. D¡¢.OR. .NOT. .AND.

26¡¢Èç¹ûÒ»¸öÔËËã±í´ïʽÖаüº¬ÓÐÂß¼­ÔËËã¡¢¹ØÏµÔËËãºÍËãÊõÔËË㣬²¢ÇÒÆäÖÐδÓÃÔ²À¨ºÅ¹æ¶¨ÕâЩÔËËãµÄÏȺó˳Ðò£¬ÄÇôÕâÑùµÄ×ÛºÏÐͱí´ïʽµÄÔËËã˳ÐòÊÇ( )¡£ A¡¢Âß¼­->ËãÊõ->¹ØÏµ B¡¢¹ØÏµ->Âß¼­->ËãÊõ C¡¢ËãÊõ->Âß¼­->¹ØÏµ D¡¢ËãÊõ->¹ØÏµ->Âß¼­ 27¡¢ÔÚÏÂÁбí´ïʽÖУ¬´íÎóµÄ±í´ïʽÊÇ£¨ £©¡£ A¡¢x<=y B¡¢X>100.AND.Y<50 C¡¢\×Ü·Ö£º\×Ü·Ö D¡¢\ÐÕÃû£º\ÐÕÃû

28¡¢µ±¼ÆËã×ÛºÏÐͱí´ïʽ(10+5<30.OR..T..AND.\ʱ£¬ÆäÔËËã˳ÐòÊÇ£¨ £©¡£ A¡¢+£­<$.AND..OR. B¡¢+<.OR..AND.£­$ C¡¢.OR..AND.+<£­$ D¡¢$.OR..AND. <+£­ 29¡¢ÏÂÁбí´ïʽÖУ¬ÕýÈ·µÄ±í´ïʽÊÇ£¨ £©¡£

A¡¢256<.T. AND 30=(\B¡¢256<100.AND.30=(12+25) C¡¢\D¡¢256<100AND30=(12+25) 30¡¢ÏÂÁбí´ïʽÖУ¬ÆäÔËËã½á¹ûΪ.T.µÄÊÇ£¨ £©¡£ A¡¢20/4-2 B¡¢\¼ÆËã»úרҵ\¼ÆËã»ú\C¡¢\D¡¢\ËÄ\ËÄ´¨\

31¡¢ÉèX=\£¬Y=\£¬ÆäֵΪÂß¼­¼ÙµÄ±í´ïʽÊÇ£¨ £©¡£ A¡¢X$Y.AND.(X==Y).OR.(\B¡¢X+Y$\

C¡¢.NOT.X$Y.AND..NOT.X=Y D¡¢.NOT.Y-X=\32¡¢ÉèÓÐÒÔÏÂÒ»×ۺϱí´ïʽ£º

200<100+15 AND \ NOT \¸Ã±í´ïʽµÄÔËËã½á¹ûΪ£¨ £©¡£

A¡¢.T. B¡¢.F. C¡¢ÆäÖµ²»ÄÜÈ·¶¨ D¡¢Ò»¸öÊýÖµ 33¡¢É裺ÄêÁä=25¡¢ÐÔ±ð=\Å®\¡¢»é·ñ=.F.¡¢Ö°³Æ=\½²Ê¦\¡¢¹¤×Ê=450£¬ÓÐÏÂÁбí´ïʽ£º£¨1£©.NOT.»é·ñ.AND.ÐÔ±ð=\Å®\£¨2£©ÐÔ±ð=\Å®\Ö°³Æ=\½ÌÊÚ\¹¤×Ê<=400.OR.ÄêÁä>30£¨3£©£¨ÄêÁä>20.OR.¹¤×Ê<=400).AND..NOT.Ö°³Æ=\½²Ê¦\

A¡¢.T.¡¢.F.¡¢.F. B¡¢.F.¡¢.T.¡¢.T. C¡¢.F.¡¢.F.¡¢.T. D¡¢.T.¡¢.F.¡¢.T. 34¡¢ÏÂÁбí´ïʽµÄ½á¹ûΪÂß¼­ÖµÕæµÄ±í´ïʽÊÇ£¨ £©¡£

A¡¢\ B¡¢\C¡¢'ABXYZPK'$\ D¡¢[AB]$\35¡¢ÏÂÁбí´ïʽµÄ½á¹ûΪÂß¼­ÖµÕæµÄ±í´ïʽÊÇ£¨ £©¡£ A¡¢\B¡¢.NOT.2**3<>8.AND.\

C¡¢\D¡¢\ºì\½­Ð¡ºì\36¡¢±í´ïʽ£­2^2*2µÄÔËËã½á¹ûΪ£¨ £©¡£ A¡¢-16 B¡¢16 C¡¢-8 D¡¢8 37¡¢ÔÚĬÈÏ״̬Ï£¬ÔÚÃüÁî´°¿ÚÖ´ÐÐÏÂÁÐÃüÁîºó£º ?'ABC'='AB' ?'ABC'>'AB'

Á½ÌõÊä³öÃüÁÏȺóÊä³öµÄ½á¹ûΪ£¨ £©¡£

A¡¢.T.¡¢.F. B¡¢.F.¡¢.F. C¡¢.F.¡¢.T. D¡¢.T.¡¢.T. 38¡¢Ö´ÐÐÏÂÁÐÃüÁîºó£º SET EXACT OFF ?'¼Ò'='¼ÒÍ¥' ?'¹ØÏµ'='¹Ø'

Á½ÌõÊä³öÃüÁÏȺóÊä³öµÄ½á¹ûΪ£¨ £©¡£

A¡¢.T.¡¢.F. B¡¢.F.¡¢.F. C¡¢.F.¡¢.T. D¡¢.T.¡¢.T. 39¡¢±í´ïʽ('ABC'#'EFG')µÄÔËËã½á¹ûÊÇ£¨ £©¡£

A¡¢\ B¡¢\ C¡¢.F. D¡¢.T. 40¡¢ÔÚVFP6.0ÖУ¬ÕýÈ·µÄÈÕÆÚÐͳ£ÊýÊÇ£¨ £©¡£ A¡¢02.08.10 B¡¢\C¡¢CTOD(\D¡¢97Äê8ÔÂ10ÈÕ

41¡¢Èô°´¸ñʽ£¨ÈÕÆÚ1-ÈÕÆÚ2£©¼ÆËãÁ½¸öÈÕÆÚÖµ£¬ÆäÔËËã½á¹ûΪ£¨ £©ÐÍÊý¾Ý¡£ A¡¢ÈÕÆÚ B¡¢Âß¼­ C¡¢×Ö·û D¡¢ÊýÖµ

42¡¢ÉèD1ºÍD2ΪÈÕÆÚÐÍÊý¾Ý£¬MΪÕûÊý£¬²»ÄܽøÐеÄÔËËãÊÇ£¨ £©¡£ A¡¢D1+D2 B¡¢D1-D2 C¡¢D1+M D¡¢D2-M

43¡¢ÔÚϵͳĬÈÏÈÕÆÚ¸ñʽÏ£¬CTOD(\µÄÔËËã½á¹ûΪ£¨ £©¡£ A¡¢CTOD(\B¡¢CTOD(\ C¡¢CTOD(\D¡¢CTOD(\

44¡¢Ê½×ÓCTOD('97.4.16')-CTOD(97.4.2)µÄÔËËã½á¹ûΪ£¨ £©¡£ A¡¢97.4.14 B¡¢³ö´íÐÅÏ¢£¨º¯Êý²ÎÊý´í£¡£© C¡¢97.4.18 D¡¢97.4.16

45¡¢Ö´ÐÐSTORE CTOD('04/21/97') TO A ÃüÁîºó£¬±äÁ¿AµÄÀàÐÍΪ£¨ £©¡£ A¡¢ÊýÖµÐÍ B¡¢ÈÕÆÚÐÍ C¡¢±¸×¢ÐÍ D¡¢×Ö·ûÐÍ

46¡¢ÔÚÏÂÁÐÓйظøA,B,C¸³ÖµµÄÃüÁîÖУ¬ÕýÈ·µÄÃüÁîÊÇ£¨ £©¡£ A¡¢STORE \ B¡¢STORE 10,20 TO A,B C¡¢STORE '.T.','ABC' TO C D¡¢A=B=8

47¡¢ÃüÁî?SUBSTR(\¸úÎÒѧÊý¾Ý¿â°É\µÄ½á¹ûÊÇ( )¡£

A¡¢ ѧÊý¾Ý¿â B)¡¢ÎÒѧ C¡¢Ñ§Êý D¡¢ Êý¾Ý¿â°É

48¡¢Êý¾Ý¿âDB£¬Êý¾Ý¿âϵͳDBS£¬Êý¾Ý¿â¹ÜÀíϵͳDBMSÈýÕßÖ®¼äµÄ¹ØÏµÊÇ( )¡£ A¡¢DBS°üÀ¨DBºÍDBMS B¡¢ DBMS°üÀ¨DBºÍDBS

C¡¢ DB°üÀ¨DBSºÍDBMS D¡¢ DBS¾ÍÊÇDB£¬Ò²¾ÍÊÇDBMS

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