Microsoft KB Archive/139527

= How to Create a Table that Has Many Fields of Identical Size =

Article ID: 139527

Article Last Modified on 2/10/2000

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q139527



SUMMARY
Creating tables that contain many fields can be time consuming, especially if all the fields have the same type and size. With a few lines of code, the table can be created easily.



MORE INFORMATION
The following program creates a table called newtable that has 200 fields, each defined as a character field of size 20: lnTblstr="("  FOR lnI=1 to 200     lnTblstr=lnTblstr+"FLD"+ALLTRIM(STR(lnI))+" C(20),"   ENDFOR   lnTblstr=STUFF(lnTblstr,LEN(lnTblstr),1,")") CREATE TABLE newtable FREE &lnTblstr

Additional query words: VFoxWin kbhowto

Keywords: kbhowto kbcode KB139527

-

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

© Microsoft Corporation. All rights reserved.