FIX: "Data Type Mismatch" Error Message Using ASORT()

MS-DOS          | WINDOWS

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
• Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SYMPTOMS

The FoxPro ASORT() function sorts an array into ascending or descending order. When an application uses the ASORT() function, all the elements in the array must have the same data type (character, numeric, date, or logical). Otherwise, the ASORT() function causes a "data type mismatch" error.

NOTE: This bug does not occur in FoxPro for Macintosh.

WORKAROUND

Use the following code to sort the array by the character field:

   USE SYS(2004)+"\Tutorial\INVOICES"
   SELECT cno,idate,ino from invoices INTO ARRAY ainv
   =ASORT(ainv,aelement(ainv,1,1))
   DISPLAY MEMORY

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.5b for Windows.

REFERENCES

Microsoft FoxPro "Commands & Functions" manual, chapter 3 "Commands and Functions, ASORT()"