Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rebuild indexes
Message
From
11/10/2004 12:23:52
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
11/10/2004 07:08:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00950359
Message ID:
00950463
Views:
10
>hi all,
>
>i make an index at myform as
>
>index on billno to kk
>when i run my table i get a repate mesaage to reindex again,
>
>i put at my form (set safety off)
>but still,
>any idea.
>thanks

Let me ellaborate on Tore's comment.

You can create a temporary index like this:
index on billno to kk
This will go to a separate file, with extension .IDX.

Or, you can use a permanent index like this:
index on billno tag billno
The permanent index will be part of a CDX file (if your table is called invoice.dbf, the indices will be part of the file invoice.cdx). The indices will be opened automatically with the table, and updated every time you add or change a record.

Normally, it is better to use the permanent index.

Once you have one, instead of:
use MyTable
index on billno to kk
use the following commands:
use MyTable order Billno
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform