Microsoft KB Archive/281385

= PRB: Visual FoxPro May Not Display All Fields of a dBase Table =

Article ID: 281385

Article Last Modified on 5/12/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Visual FoxPro 7.0 Professional Edition

-



This article was previously published under Q281385



SYMPTOMS
When you open a Visual dBase table in Visual FoxPro, and you browse or list the structure of the table, some of the fields may not be available when the data is accessed. You do not receive an error message.



CAUSE
Visual FoxPro cannot read a Visual dBase field whose name begins with a digit.



RESOLUTION
When you create the structure of the Visual dBase table, make sure that the name of every field starts with a character. Numeric or other values can follow the first character in the name, but the first character must be either a letter or an underscore.



MORE INFORMATION
When Visual FoxPro attempts to read a Visual dBase field name that begins with a digit, it does not give an error; however, it does not display any fields after that field. For example, if the Visual dBase table has ten fields in its structure and the name of the fifth field starts with a digit, you see only the first four fields in the table. Visual FoxPro reads all of the records, but only displays the first four fields of each record.

Steps to Reproduce Behavior

 * 1) In Visual dBase, create a table, and add six fields to the structure of the table. Name the fields Fld1, Fld2, Fld3, 1fld4, Fld5, and Fld6.
 * 2) Add a few records to the table, and close the table.
 * 3) In Visual FoxPro, open the table. . When you browse or list the structure of the table, only the first three fields appear.

