Knowledge Base

FIX: COPY STRUCTURE EXTENDED Ignores Long Field Names

Article ID: 131215

Article Last Modified on 9/30/2003


APPLIES TO


This article was previously published under Q131215

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
				

Keywords: kbbug kbfix kbvfp500fix KB131215