WD: Updating DATABASE Field May Change Results

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.

Additional query words: 6.0 odbc winword word6 7.0a word97 6.0a 6.0c 7.0 word95 word7

Keywords : kbfield kbmerge
Version : WINDOWS:6.0,6.0a,6.0c,7.0,7.0a; :
Platform : WINDOWS
Issue type :