PRB: Error Message: "No bars have been defined for this popup"

• Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6, 2.6a
• Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, 2.5b, 2.6, 2.6a

SYMPTOMS

If the PROMPT FIELD clause of a DEFINE POPUP command contains empty records, the following error message occurs:

   No bars have been defined for this popup

CAUSE

This error can be caused by any one of the following:

• The field used in the PROMPT FIELD expression is from an empty permanent or temporary table.

  -or-

• A SET FILTER command was issued, and no records satisfied the filter condition.

  -or-

• An SQL SELECT command resulted in an empty cursor or table.

RESOLUTION

Check for the following:

1. Existing records in permanent or temporary tables.

2. Misspellings in the filtering or query command lines.

3. Field values containing upper- or lower-case characters.

STATUS

This behavior is by design.

MORE INFORMATION

In some cases it may be necessary to check for empty records before defining and activating the popup. The code provided below uses the _TALLY system memory variable to determine if the result of an SQL SELECT command is greater than one before it populates the popup. Add the following code after the SQL SELECT command:

   IF _TALLY < 1
      WAIT WINDOW "No Records Available"
   ELSE
      *(insert DEFINE POPUP command line)
      *(insert ACTIVATE POPUP command line)
   ENDIF

Steps to Reproduce Behavior

Create and run the following program:

   *** Begin Program ***

   CLOSE DATABASES
   USE C:\FPW26\TUTORIAL\CUSTOMER
   SET FILTER TO state = "nc"    && 'nc' must be in lowercase

   DEFINE POPUP cities FROM 5,5 TO 15,25 PROMPT FIELD city SCROLL
   ACTIVATE POPUP cities

   DEACTIVATE POPUP cities
   SET FILTER TO
   CLOSE DATABASES

   *** End Program ***

You can modify the program to produce the same error using the SQL SELECT statement. For example, change the SET FILTER TO command line into a comment. Then below that command line, add this code:

      SELECT * FROM customer WHERE state = "nc" INTO CURSOR temp

The error also occurs if no records have been added to the permanent table or if the records in the permanent table have been removed using the ZAP, PACK, or DELETE (if SET DELETED is ON) commands.