谢谢
以ä¸æ¯VFPä¸å¯¹foundå½æ°ç说æï¼
ç¡®å®æè¿æ§è¡ç CONTINUEãFINDãLOCATE æ SEEK
å½ä»¤æ¯å¦æåï¼æå¨å ³ç³»è¡¨ä¸çè®°å½æéæ¯å¦è¢«ç§»å¨ã
æ示ï¼
å¯ä»¥ç¨ FOUND( ) æ¥ç¡®å®å表æ¯å¦æè®°å½ä¸ç¶è®°å½å¹é ã
FOUND([nWorkArea | cTableAlias])
åæ°
nWorkArea
æå®æè¿ç¨ CONTINUEãFINDãLOCATE æ SEEK å½ä»¤è°ç¨ç表æå¨çå·¥ä½åºã
cTableAlias
æå®æè¿ç¨ CONTINUEãFINDãLOCATE æ SEEK å½ä»¤è°ç¨ç表çå«åã
注æï¼
å¦æææå®ç表å«åä¸åå¨ï¼Visual FoxPro
å°äº§çé误信æ¯ã
ã
è¿åå¼
é»è¾åãå¦ææè¿æ§è¡ç CONTINUEãFINDãLOCATE æ SEEK
å½ä»¤æåï¼å FOUND( ) è¿åâçâ(.T.)ï¼å¦åè¿åâåâ(.F.)ãå¦ææå®å·¥ä½åºç表没æ被æå¼ï¼FOUND( )
è¿åâåâãå½ FOUND( ) éå°å¯ç¨ EOF( )
å½æ°æµå®çæ件çæ«å°¾ï¼æ»æ¯è¿åâåâã
说æ
å¦æè°ç¨ä¸å¸¦åæ°ç FOUND( )ï¼FOUND( )
çæä½å¯¹è±¡æ¯å½åéå®å·¥ä½åºæå¼ç表ã
示ä¾
å¨ä¸é¢ç示ä¾ä¸ï¼æ¥æ¾åç»è®¡å¨ Customer è¡¨ä¸ Country å段çææâå¾·å½(GERMANY)â客æ·çæ°éãCLOSE
DATABASES å ³éæææ°æ®åºï¼OPEN DATABASE æå¼ Visual FoxPro 示ä¾æ°æ®åº
TestData.dbcãUSE æå¼ Customer 表ã
STORE åå¨ 0 å°åé gnCount ä¸ãLOCATE æç´¢ Country å段å å« "GERMANY"
å¼ç第ä¸æ¡è®°å½ãDO WHILE 循ç¯æ¯æ¬¡ä½¿åé gnCount å¢å 1ï¼å¹¶ä½¿ç¨ CONTINUE æ¥æ§è¡åä¸ä¸ª
LOCATE æä½ãå½å没æå¹é çè®°å½æ¶ï¼å°±æ¾ç¤ºå®¢æ·çå计æ°ã
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\TestData')
USE Customer
STORE 0 TO gnCount
LOCATE FOR UPPER(Country)='GERMANY'
DO WHILE FOUND()
gnCount = gnCount + 1
CONTINUE
ENDDO
? "Total customers from Germany: "+LTRIM(STR(gnCount))
ç¡®å®æè¿æ§è¡ç CONTINUEãFINDãLOCATE æ SEEK
å½ä»¤æ¯å¦æåï¼æå¨å ³ç³»è¡¨ä¸çè®°å½æéæ¯å¦è¢«ç§»å¨ã
æ示ï¼
å¯ä»¥ç¨ FOUND( ) æ¥ç¡®å®å表æ¯å¦æè®°å½ä¸ç¶è®°å½å¹é ã
FOUND([nWorkArea | cTableAlias])
åæ°
nWorkArea
æå®æè¿ç¨ CONTINUEãFINDãLOCATE æ SEEK å½ä»¤è°ç¨ç表æå¨çå·¥ä½åºã
cTableAlias
æå®æè¿ç¨ CONTINUEãFINDãLOCATE æ SEEK å½ä»¤è°ç¨ç表çå«åã
注æï¼
å¦æææå®ç表å«åä¸åå¨ï¼Visual FoxPro
å°äº§çé误信æ¯ã
ã
è¿åå¼
é»è¾åãå¦ææè¿æ§è¡ç CONTINUEãFINDãLOCATE æ SEEK
å½ä»¤æåï¼å FOUND( ) è¿åâçâ(.T.)ï¼å¦åè¿åâåâ(.F.)ãå¦ææå®å·¥ä½åºç表没æ被æå¼ï¼FOUND( )
è¿åâåâãå½ FOUND( ) éå°å¯ç¨ EOF( )
å½æ°æµå®çæ件çæ«å°¾ï¼æ»æ¯è¿åâåâã
说æ
å¦æè°ç¨ä¸å¸¦åæ°ç FOUND( )ï¼FOUND( )
çæä½å¯¹è±¡æ¯å½åéå®å·¥ä½åºæå¼ç表ã
示ä¾
å¨ä¸é¢ç示ä¾ä¸ï¼æ¥æ¾åç»è®¡å¨ Customer è¡¨ä¸ Country å段çææâå¾·å½(GERMANY)â客æ·çæ°éãCLOSE
DATABASES å ³éæææ°æ®åºï¼OPEN DATABASE æå¼ Visual FoxPro 示ä¾æ°æ®åº
TestData.dbcãUSE æå¼ Customer 表ã
STORE åå¨ 0 å°åé gnCount ä¸ãLOCATE æç´¢ Country å段å å« "GERMANY"
å¼ç第ä¸æ¡è®°å½ãDO WHILE 循ç¯æ¯æ¬¡ä½¿åé gnCount å¢å 1ï¼å¹¶ä½¿ç¨ CONTINUE æ¥æ§è¡åä¸ä¸ª
LOCATE æä½ãå½å没æå¹é çè®°å½æ¶ï¼å°±æ¾ç¤ºå®¢æ·çå计æ°ã
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\TestData')
USE Customer
STORE 0 TO gnCount
LOCATE FOR UPPER(Country)='GERMANY'
DO WHILE FOUND()
gnCount = gnCount + 1
CONTINUE
ENDDO
? "Total customers from Germany: "+LTRIM(STR(gnCount))
温馨提示:答案为网友推荐,仅供参考
第1个回答 2009-06-08
就是找到的意思,本函数检查上一个搜索语句是否找到满足条件的记录,找到的时候返回真,否则假。本回答被提问者采纳
第2个回答 2015-12-09
就是找到的意思,本函数检查上一个搜索语句是否找到满足条件的记录,找到的时候返回真,否则假。
第3个回答 2009-06-08
54