Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't get the right Index open with the table....
Message
De
23/08/2000 16:57:45
 
 
À
23/08/2000 16:53:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00408500
Message ID:
00408504
Vues:
16
>I need a little help with creating Index's in a Visual
>FoxPro program. I can't seem to get the right index
>open with the .dbf table I want to seek on. In the
>following example, the SYS commands show:
>SYS(21) 1
>SYS(22) TK1
>Instead of MCODES.
>What am I doing wrong? Help....
>
>Example of code:
>USE PRCODES IN A
>INDEX ON PRCODES.CODETYPE + PRCODES.STUBDESC TO MCODES
>USE PUNCH IN D
>USE TK001 IN C
>INDEX ON TK001.U_ENO + TK001.U_COM + TK001.U_CODE TO TK1

The index is created on the currently selected table. Make sure the table you want to index is SELECTed before issuing the INDEX ON.
Also, I recommend not using the USE ... IN A but rather USE ... IN 0 to get the first available work area. Otherwise you could close a table you didn't want to.
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform