PRB: Numeric Field Incorrectly Rounds to Two Decimal Places

ID: Q99538

The information in this article applies to:

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

SYMPTOMS

The last two decimal places in a numeric field may be truncated when you type the data in the BROWSE window.

CAUSE

Steps to Reproduce Problem

1. CREATE a database with one numeric field size 19 with four decimal

   places.

3. Enter the following:

      12345678910111.2599

   The value displayed is 12345678910111.2500.

      1234567891011.2599

   The value displayed is 12345678910111.2590.

RESOLUTION

To display all four decimal places, create a numeric field size 17 with four decimal places.

Additional reference words: FoxWin FoxDos 2.00 2.50 2.50a floating far KBCategory: kbprg kbprb KBSubcategory: FxprgBrowse

Last Reviewed: June 27, 1995