FIX: Crosstab Query Returns Empty String When STR() Used

ID: Q126970

2.5x 2.60 | 2.5x 2.60

WINDOWS   | MS-DOS

The information in this article applies to:

• Microsoft FoxPro for Windows, version 2.5x, 2.6
• Microsoft FoxPro for MS-DOS, version 2.5x, 2.6

SYMPTOMS

When creating a crosstab query, if the third field (numeric field) is specified as STR(<third field>), an empty string is returned when the query is generated.

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 and FoxPro version 2.6a for MS-DOS.

MORE INFORMATION

Steps to Reproduce Problem

1. Create a table with the following structure:

   Field Name  Type       Width
   ----------------------------
   MYROWS      Character     3
   MYCOLS      Character     3
   MYCELL      Numeric       3

   MYROWS  MYCOLS  MYCELL
   ----------------------
     A      A           1
     A      B           2
     A      C           3
     B      A           4
     B      B           5
     B      C           6

   quotation marks) in the Command Window. In the resultant RQBE, click
   Fields. Then in the Select Fields dialog, click the Cross Tabulate box.
   Run the query and you will get the correct output.

   MYROWS    A   B    C
   --------------------
     A       1   2    3
     B       4   5    6

   list. Type STR(MYCELL) into the function/expression section and move the
   expression into the Selected Output list. Run the query and the
   resulting cursor shows a blank or empty value in MYCELL:

   MYROWS    A   B    C
   --------------------
     A
     B