Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103354

From BetaArchive Wiki

PRB: SQL SELECT Command Does Not Recognize SET FILTER TO

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


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


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.


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

Last Reviewed: June 27, 1995
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.