FIX: COPY STRUCTURE EXTENDED Ignores Long Field Names

ID: Q131215

3.00 3.00b WINDOWS kbprg kbbuglist kbfixlist

The information in this article applies to:

Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b

SYMPTOMS

Visual FoxPro's COPY STRUCTURE EXTENDED command was enhanced to provide for many of the new properties that a table may have, but it still only observes standard-length (10 character) field names. It ignores long field names.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in Visual FoxPro 5.0 for Windows.

MORE INFORMATION

Steps to Reproduce Problem

Issue the following commands in the Command window:

   CREATE DATABASE mydbc
   CREATE TABLE mytbl (a2345678901234 c(3))
   COPY STRUCTURE EXTENDED TO backup
   USE backup
   CREATE mytbl2 FROM backup

Note the field name in mytbl2 is only 10 characters (a123456789).

NOTE: Though the COPY STRUCTURE EXTENDED command has been corrected, in order to create a table that uses the same long field names, you must specify the database name and long table name for the new table. For the example above, change the last CREATE command as follows:

   CREATE mytbl2 DATABASE mydbc NAME mytbl2 FROM backup

KBCategory: kbprg kbbuglist kbfixlist KBSubcategory: FxprgTable fixlist5.00 VFoxWin buglist3.00 buglist3.00b Additional reference words: 3.00 3.00b

Keywords          : kbVFp kbVFp300bbug kbVFp500fix buglist3.00 FxprgTable kbbuglist kbfixlist
Version           : 3.00 3.00b
Platform          : WINDOWS
Solution Type     : kbfix