Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Recreating indexes
Message
De
08/10/2003 17:53:01
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
08/10/2003 12:17:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00836292
Message ID:
00836530
Vues:
10
Structural CDX indexes are built where the data is. For IDX and non structural CDXs you could ...
USE TABLE
LOCAL lcDir
lcDir = ADDBS(JUSTPATH(DBF("TABLE")))
*IDX
INDEX ON index_expression TO (m.lcDir+"idx_file_name")
*Non structural CDX
INDEX ON index_expression TAG tag_name OF (m.lcDIR+"cdx_file_name")
HTH

>I am moving an old application converted from Foxpro for Windows 2.6 to Visual foxpro 5 to Visual Foxpro 8. The original author is long gone. While testing I found that a program m which is suppose to recreate indexes does not work. I am trying to generalize it so that folders do not have to be hard wired and so that program is not dependent on other code. I know that data is going to be be in subfolder \data of the executing program. The glitch that I found is that when looking at "Data" of the project manager the table name does not match the dbf name shown in the path, i.e
>
> project manager name status
> path dbf namme pop1.dbf
>
>What is the best way of handling this situation?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform