PRB: "Variable Not Found" Error Occurs with Filter Expression

• Microsoft FoxPro for MS-DOS, versions 2.00, 2.5x, 2.6, 2.6a
• Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a
• Microsoft FoxPro for Macintosh, versions 2.5x
• Microsoft FoxPro for UNIX, version 2.6

SYMPTOMS

When you are performing a SEEK, a LOCATE, or a FIND, the following error message occurs:

   Variable '<variable name>' not found.

CAUSE

A filter expression has been set, and it uses the variable that can no longer be found. When the filter expression is reevaluated during the search, FoxPro reports that the variable cannot be found.

RESOLUTION

While every case is likely to be different, the problem illustrated below could be resolved in one of the following ways:

1. Make the variable used in the filter expression PUBLIC.

   NOTE: Verify that the code does not contain a PRIVATE command that makes the variable in question private.

   -or-

2. Change the SetFilter procedure to the following:

         PROCEDURE SetFilter
         PARAMETER x
         cExpr = 'state ="'+ x + '"'
         SET FILTER TO &cExpr
   

MORE INFORMATION

Steps to Reproduce Behavior

1. Enter the following code in a program:

         USE customer
         INDEX ON cno TAG cno
   

         DO SetFilter WITH 'CA'
         SEEK 'A2695'
   

         PROCEDURE SetFilter
         PARAMETER x
         SET FILTER TO state=x
   

2. Run the program.