Microsoft KB Archive/156923

= PRB: IMPORT FROM Paradox Fails on Numeric Fields on Macintosh =

Article ID: 156923

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0b for Macintosh
 * Microsoft FoxPro 2.6a Professional Edition for Macintosh

-



This article was previously published under Q156923



SYMPTOMS
The conversion of a Paradox database that contains numeric fields to Visual FoxPro for Macintosh 3.0b or FoxPro for Macintosh 2.6a results in a table with numeric fields that now contain zeros. The error "Numeric overflow, data was lost" may also appear. This behavior does not occur with Visual FoxPro for Windows.



WORKAROUND
Possible workarounds include the following:


 * Convert the numeric fields to character fields within Paradox, before importing and then back to numeric fields in FoxPro once the import is complete.
 * Save the Paradox table out to a delimited text file and then use the FoxPro command APPEND FROM TYPE DELIMITED, to import the data into a newly defined table structure in FoxPro.
 * Import the Paradox table into Visual FoxPro for Windows and then transport the table over to the Macintosh.



STATUS
Microsoft is researching this behavior and will post new information here in the Microsoft Knowledge Base as it becomes available.



Steps to Reproduce Behavior
Using a Paradox table, type the following command in FoxPro:

IMPORT FROM  TYPE PDOX

The numeric fields within the FoxPro table contain zeros and the error "Numeric overflow, data was lost" may occur. The Character fields import correctly.

Additional query words: kbdse VFoxMac FoxMac

Keywords: kb3rdparty KB156923

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.