MasteringVFP/4/8

http://www.textcaacour.com 
=== å¼·å¤§ç Filter ===
å¨æ©æç¡æ³ä½¿ç¨ SQL çæå,è¦å¦ä½ç¯©é¸è³æå¢??éæåå°±æ¯ç¨ Filter å¦...
èªªå° Filter, ä»çæ·å²å¯æ¯å¾æ ä¹çå¢~å¨ dBase æä»£å°±å·²ç¶åå¨äº.
è¨å® Filter çæ¹æ³å¾ç°¡å®,å°±æ¯éæ¨£å:
<pre>
set filter to æ¬ä½=å¼
</pre>
èåæ¶ä¹åæ¨£çå®¹æ:
<pre>
set filter to
</pre>

å¨ä»¥å,å·è¡å® set filter to ä»¥å¾,æå¥½è¦ç§»åä¸ä¸ç´é,è® Filter çæ,ä¾å¦ go top, ææ¯ go bottom...,å¦åä½ æå¯è½ç¼ç¾,Filter æ²æçæ...

ä¸é¢æåå°±èåç°¡å®çä¾å,éè£¡æ¯æææå®¢æ¶ç·¨èåé¢çº "S01" çäººé½ browse åºä¾.
<pre>
use customers
set filter to customers.id="S01"
go top
browse
</pre>
æ³¨æå,éè£çºä»éº¼èªªææææå®¢æ¶ç·¨èåé¢çº "S01" çäººé½ browse åºä¾å¢??éåå,æ¯å çº VFP å¯ä»¥é¸æåæä¸åç²¾ç¢ºæ¯å°( set exact on / set exact off ).
æè¬çç²¾ç¢ºæ¯å°,ææå°±æ¯å¿é è¦å®å¨ç¬¦å,æ¢ä»¶æææç«,ä¹å°±æ¯èªª "S01" æçæ¼ "S01" èä¸çæ¼ "S0100".
VFP é è¨è¡çºæ¯éç²¾ç¢ºæ¯å°,ä¹å°±æ¯èªª "S01" æçæ¼ "S0100" ä¹æçæ¼ "S01".
éåè¨å®å¯ä»¥ç´æ¥å° ((MasteringVFP/1/4|Options)) å»è¨å®,ä¹å¯ä»¥ç´æ¥ä½¿ç¨ set exact å»è¨å®çº on æ off.

å°éè£¡,ç¸ä¿¡é½æç½ Filter å¦ä½ä½¿ç¨äºå§~
ä¸é,å¦æä½  Remote View + Filter çæå,æç¼ç¾æçå¾æ¢.
éæ¯å çº Filter æéè¦ææè³æ,æè½åç¯©é¸çåä½,æä»¥ Remote View æè©¦åä¸è¼ææé ç«¯è³æåä¾.ä½éä¹ä¸æ¯èªª Filter ä¸å¥½,åªæ¯,ä½ å¿é è¦äºè§£ä»çåªç¼ºé»,èå¶ä»æä»¤äº¤äºæéä½¿ç¨,æè½ç¼æ®å®çæå.