FIX: CREATE REPORT on SELECT-SQL Cursor Uses Original Fields

The information in this article applies to:

• Microsoft FoxPro for Windows, version 2.6

SYMPTOMS

After you issue a SELECT-SQL statement in FoxPro version 2.6 for Windows and limit the fields that end up in the new table or cursor, running the CREATE REPORT command on the newly created table or cursor brings up all the fields from the original table. This behavior occurs even when the original table is closed. This behavior cannot be duplicated in any other version of FoxPro.

CAUSE

This problem only occurs when there are no additional clauses (such as WHERE or HAVING) on the SELECT statement.

RESOLUTION

To work around this problem, add a WHERE, HAVING, ORDER BY, or GROUP BY clause to the SELECT statement. If you don't need a clause, add WHERE .T. to the end of the SELECT statement; for example:

   SELECT customer.cno, customer.state;
      FROM customer;
      INTO CURSOR test WHERE .T.
   CREATE REPORT test.frx FROM test WIDTH 788
   REPORT FORM test.frx PREVIEW

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in FoxPro version 2.6a for Windows.

MORE INFORMATION

Steps to Reproduce Behavior

Execute the following commands:

   SELECT customer.cno, customer.state;
      FROM customer;
      INTO CURSOR test
   CREATE REPORT test.frx FROM test WIDTH 788
   REPORT FORM test.frx PREVIEW