PRB: RQBE Having Window Causes Error Type 11 Message

• Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS

Using the BETWEEN() function in the Having window of the RQBE builder may result in a type 11 error or may hang the machine.

WORKAROUND

Use the Selection Criteria section of the RQBE Builder to create a WHERE clause that contains the BETWEEN() function to filter the records.

STATUS

Microsoft is researching this behavior and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Using the Having window to create filter conditions for records may produce erroneous errors or hang the machine. Placing the BETWEEN() function in a series of three or more conditions separated by "or" clauses frequently causes this behavior. However, the symptoms vary between machines. Starting the machine with extensions ON also influences the type of error message encountered. Regardless of the environment, using the BETWEEN() function in the Having window produces one of two error conditions. First, the system may report an erroneous type 11 error that points to a hardware problem. Second, while in the RQBE, the machine may simply hang, forcing the programmer to reboot.

Several different scenarios may cause these anomalies to occur. First, the errors may occur when clicking the OK button in the Having window. Second, they may occur when actually executing the query. Third, the error may appear when attempting to re-enter the Having window to modify the query. Finally, actually editing the filter conditions in the Having window may cause the error.

Steps to Reproduce Behavior

1. Open the Clients table located in the Sample\Organize\DBFS folder.

2. Type "Create Query" (without the quotation marks) in the Command window.

3. Click the Having check box, and enter three filter conditions using the BETWEEN() function based on the zip field.

4. Attempt to click the OK button to close the Having window.

5. Click the Do Query button to execute the query.

6. Close the browse window, return to the RQBE builder screen, and click the Having checkbox.

7. Attempt to remove one or more of the filter conditions.