FIX: Invalid Page Fault After Summing Currency Field of Cursor (157762)

The information in this article applies to:

Microsoft Visual FoxPro for Windows 5.0

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).

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbBug kbProgramming kbvfp500aFIX KB157762