WD: Updating DATABASE Field May Change Results

 Last reviewed: February 5, 1998
Article ID: Q109569
The information in this article applies to:
  • Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
  • Microsoft Word for Windows 95, versions 7.0, 7.0a
  • Microsoft Word 97 for Windows

SYMPTOMS

The contents of a DATABASE field may change when you re-sort (update) by the same criteria if the data types in one column are not consistent.

CAUSE

Word will use the first entry in a field (column) to determine what data type is in that field. If a column contains different data types, the sort order will vary if the first element is numeric, text, or date.

For example, the following database will have these three results when sorted: 

   Original        First sort:      Second sort:      Third sort:
                   numeric          alphabetic        date
   ==============================================================
   24              banana           01/8/92           24
   5               apple            12/12/93          5
   banana          01/8/92          24                apple
   apple           12/12/93         5                 banana
   12/12/93        5                apple             01/8/92
   01/8/92         24               banana            12/12/93
Fields with consistent data types will sort or update consistently within Word.

KBCategory: kbusage
KBSubcategory: kbfield kbmerge
Additional query words: 6.0 odbc winword word6 7.0a word97
6.0a 6.0c 7.0 word95 word7
Keywords : kbfield kbmerge
Version : 6.0 6.0a 6.0c 7.0 7.0a 97
Platform : WINDOWS

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: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.