Microsoft KB Archive/131215

= FIX: COPY STRUCTURE EXTENDED Ignores Long Field Names =

Article ID: 131215

Article Last Modified on 9/30/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition

-



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.



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.