Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rebuild indexes
Message
De
11/10/2004 12:23:52
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
11/10/2004 07:08:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00950359
Message ID:
00950463
Vues:
11
>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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform