Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recreating indexes
Message
From
08/10/2003 17:53:01
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
08/10/2003 12:17:05
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00836292
Message ID:
00836530
Views:
9
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?
Previous
Reply
Map
View

Click here to load this message in the networking platform