Microsoft KB Archive/103354

{| = PRB: SQL SELECT Command Does Not Recognize SET FILTER TO =
 * width="100%"|

ID: Q103354

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
 * Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SYMPTOMS
When you issue an SQL SELECT statement, the SET FILTER TO command is not taken into account.

CAUSE
Generally, when a SET FILTER TO command is issued, only the records that meet that criteria can be accessed through other FoxPro commands. However, the SQL SELECT command ignores the SET FILTER TO command because the SQL SELECT command opens the database in another work area, therefore bypassing the SET FILTER TO condition.

STATUS
This behavior is by design.

Steps to Reproduce Behavior
1. Open the CUSTOMER.DBF database in the TUTORIAL directory.

2. Issue the following command:

SET FILTER TO state = 'OH' 3. Browse the database. Only the records where the state is "OH" are shown. 4. Issue the following command: SELECT * FROM customer WHERE state = 'CA' A Browse window will appear with all the records where the state is "CA". Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a KBCategory: kbprg kbprb KBSubcategory: FxprgSql
 * }