Microsoft KB Archive/102895: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - "&" to "&") |
||
Line 12: | Line 12: | ||
<div id="TitleRow"> | <div id="TitleRow"> | ||
= <span id="KB102895"></span>How Increase & | = <span id="KB102895"></span>How Increase & Decrease Size of Compound Structural Index = | ||
Latest revision as of 12:24, 21 July 2020
Article ID: 102895
Article Last Modified on 12/3/2003
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.5a
- Microsoft FoxPro 2.0
- Microsoft FoxPro 2.5b for MS-DOS
- Microsoft FoxPro 2.5a
This article was previously published under Q102895
SUMMARY
To increase the size of a compound structural index file, repeat the INDEX ON command. To reduce the size of the .CDX file, issue the REINDEX command, or delete the tag and issue the INDEX ON command.
MORE INFORMATION
Steps to Reproduce Problem
In the Command window, issue the following commands:
USE D:\FOXPROW\TUTORIAL\CUSTOMER EXCLUSIVE **The command above assumes FoxPro version 2.5 for Windows COPY TO TEST USE TEST EXCLUSIVE INDEX ON CNO TAG CNO CLOSE ALL FILER
- Find TEST.CDX in Filer and note its size. Close Filer.
In the Command window, issue the following commands:
USE TEST EXCLUSIVE INDEX ON CNO TAG CNO **A warning may appear about overwriting tag cno. It will be **necessary to overwrite the tag. CLOSE ALL FILER
- Find TEST.CDX in Filer and note the increase in size. Close Filer.
In the Command window, issue the following commands:
USE TEST EXCLUSIVE REINDEX CLOSE ALL FILER
- Find TEST.CDX in Filer and note that its size has been reduced.
Additional query words: VFoxWin FoxDos FoxWin
Keywords: KB102895