Knowledge Base

FIX: Invalid Page Fault After Summing Currency Field of Cursor

Article ID: 157762

Article Last Modified on 10/16/2002

Microsoft Visual FoxPro 5.0 Standard Edition

This article was previously published under Q157762

SYMPTOMS

After using the CALCULATE command to SUM the contents of a currency field in a cursor file, and storing that sum in a variable, the resulting variable may cause system errors in subsequent operations. For example, one error is as follows:

Vfp.exe caused an Invalid Page Fault

WORKAROUND

Do one of the following:

Use the SET TALK ON command. -or-
Change the field type to something other than currency.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in Visual FoxPro 5.0a.

MORE INFORMATION

Steps to Reproduce Behavior

The following sequence of commands result in the error described above:

   SET TALK OFF
   CREATE CURSOR test (nAmount Y)
   CALCULATE ALL SUM(nAmount) TO nTotal
   ? nTotal # 0

Make one of the changes below to work around the problem:

Change the line "SET TALK OFF" to "SET TALK ON." -or-
Change the field type in the CREATE CURSOR command to something other than currency (Y).

Keywords: kbbug kbfix kbvfp500afix kbprogramming KB157762