FIX: Memo Field Corruption Occurs with Code Page Differences

Last reviewed: October 14, 1997
Article ID: Q107520
2.50a | 2.50a
WINDOWS    | MS-DOS
kbprg kbfixlist kbbuglist

The information in this article applies to:

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

SYMPTOMS

When a table is tagged with a code page other than the current working code page, data in a memo field is lost if the memo file is reorganized.

STATUS

Microsoft has confirmed this to be a problem in FoxPro version 2.5a for MS-DOS and FoxPro 2.5a for Windows. This problem was corrected in FoxPro 2.5b for MS-DOS and FoxPro 2.5b for Windows.

MORE INFORMATION

Steps to Reproduce Problem

  1. Make sure CPZERO.PRG is in your FoxPro directory. If you are using FoxPro for Windows, use 850 as the code page parameter for CPZERO; use 1252 for FoxPro for MS-DOS.

  2. In the Command window, type the following:

    SET EXCLUSIVE ON SET SAFETY OFF CREATE TABLE test (xxx m) DO SYS(2004)+"\CPZERO" WITH "TEST.DBF",850 && or 1252 DISPLAY STATUS APPEND BLANK MODIFY MEMO xxx

  3. In the memo window, type:

    zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

  4. Press CTRL+W to close the memo field.

  5. In the Command window, issue the following command:

    APPEND BLANK

  6. In the Command window, issue the following command:

    MODIFY MEMO

  7. Repeat steps 3 and 4.

  8. In the Command window, issue the following command:

    REPLACE ALL XXX WITH "ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ"

  9. In the Command window, issue the following commands:

    PACK MODIFY MEMO XXX BROWSE

  10. In the Browse window, move to record 2. The information in the memo field will be gone.


Additional reference words: FoxDos FoxWin 2.50a buglist2.50a
fixlist2.50b
codepage
KBCategory: kbprg kbfixlist kbbuglist
KBSubcategory: FxprgIntl
Keywords : FxprgIntl kbbuglist kbfixlist kbprg
Version : 2.50a | 2.50a
Platform : MS-DOS WINDOWS
Solution Type : kbfix


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.