Knowledge Base

PRB: Length Not Updating Properly in Table Structure Dialog

Article ID: 131168

Article Last Modified on 2/15/2000

Microsoft Visual FoxPro 3.0 Standard Edition

This article was previously published under Q131168

SYMPTOMS

In the Table Structure dialog box brought up by the MODIFY STRUCTURE command, the length information displayed at the bottom of the dialog box does not seem correct. It adds one to the sum of the length of each field in the table.

CAUSE

In the status bar of the Table Structure dialog box, the length information displays the length of each record. It sums the length of each field, and adds an additional byte, which flags whether or not the record is deleted. For example, if the table has two fields, field1 C(20) and field2 C(20), the length of the record is 20+20+1=41.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Create a New table. Add:

   Field1                 C    10
   Field2                 C    20

Verify the length displayed in the status bar of the table structure dialog box.

Additional query words: VFoxWin

Keywords: KB131168