Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't get the right Index open with the table....
Message
From
23/08/2000 16:57:45
 
 
To
23/08/2000 16:53:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00408500
Message ID:
00408504
Views:
14
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform