BUG: BROWSE FORMAT with Character RANGE Causes Syntax Error

ID: Q122864

The information in this article applies to:

• Microsoft Foxpro for Windows, version 2.5, 2.5a, 2.5b, 2.6, 2.6a

SYMPTOMS

Issuing a BROWSE FORMAT command that includes a character RANGE in the format file causes a "Syntax Error."

CAUSE

When the RANGE clause is used in a FORMAT file, you can usually include character, date, and numeric data ranges of acceptable values that are used with an @ get editing region. However, if FoxPro encounters the RANGE clause while reading the format file specified in the SET FORMAT command, a "Syntax Error" is generated.

RESOLUTION

Use a VALID clause on the field instead of a range as in this example:

   * Format file :CUSTENT.FMT
   @ 1,0  SAY "CNO"
   @ 1,10 GET cno PICTURE "XXXXX" VALID testcno()
   @ 2,0  SAY "Company"
   @ 2,10 GET Company PICTURE "XXXXXXXXXXXXXXXXXXXX"

   PROCEDURE testcno
      IF cno < "22222" OR cno > "55555"
         WAIT WINDOW "Invalid CNO entered - Must be 22222 to 55555"
         RETURN 0
      ENDIF
   * End of Format File

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a Format file called CUSTENT.FMT by using these commands:

   * Format file :CUSTENT.FMT
   @ 1,0  SAY "CNO"
   @ 1,10 GET cno PICTURE "XXXXX" RANGE "22222","55555" ;
      ERROR "Invalid cno entered - must be 22222 to 55555"
   @ 2,0  SAY "Company"
   @ 2,10 GET company PICTURE "XXXXXXXXXXXXXXXXXXXX"
   * End of Format File

   MODIFY COMM MyTest

   * Program MyTest.prg

   USE Customer
   SET FORMAT TO custent.fmt
   BROWSE FORMAT

   * End of Program MyTest.prg

4. Issue the following command in the Command window:

   DO MyTest