Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fox Pro 2.6D
- Thread starter petreco
- Start date
1. Yes. If you're talking about converting a Fox DOS app to Fox Windows, there is no code conversion. The code will execute fine. There is all sorts of difference when you start talking about how the data is displayed, like using Windows fonts. The screens will display differently as well as reports. The will look, well, awful when run under windows.
If you're talking about convertinf to VFP, that's a whole different critter. Go to the Keyword Search in this forum or the VFP 3> forum and you will find more than you ever wanted to know about converting to the Visual version.
2. To reindex all indices in a single table, you can use:
USE MyTable EXCLUSIVE
REINDEX
However, I don't recommend doing it this way. Since index file headers and/or tags can become corrupted as well as index files, the indexes can be rebuilt corrupted. The best and safest way to reindex all tags in a table is to recreate them from scratch:
USE MyTable EXCLUSIVE
DISPLAY STATUS
Take note of index tags listed on the screen and close the table.
Now deleted the .CDX file, then:
USE MyTable EXCLUSIVE
Ignore the warning about the Structural CDX reference being removed.
Now manually index the file from each tag previously noted:
INDEX ON SomeField TAG SomeTag
The sam would hold true for standalone .IDX files, you just need to set the order to each index, display the status, and delete the .IDX file.
And of course, always have backups.
Dave S.
If you're talking about convertinf to VFP, that's a whole different critter. Go to the Keyword Search in this forum or the VFP 3> forum and you will find more than you ever wanted to know about converting to the Visual version.
2. To reindex all indices in a single table, you can use:
USE MyTable EXCLUSIVE
REINDEX
However, I don't recommend doing it this way. Since index file headers and/or tags can become corrupted as well as index files, the indexes can be rebuilt corrupted. The best and safest way to reindex all tags in a table is to recreate them from scratch:
USE MyTable EXCLUSIVE
DISPLAY STATUS
Take note of index tags listed on the screen and close the table.
Now deleted the .CDX file, then:
USE MyTable EXCLUSIVE
Ignore the warning about the Structural CDX reference being removed.
Now manually index the file from each tag previously noted:
INDEX ON SomeField TAG SomeTag
The sam would hold true for standalone .IDX files, you just need to set the order to each index, display the status, and delete the .IDX file.
And of course, always have backups.
Dave S.
Regarding your question on re-indexing, you could automate your index rebuilding with Dennis Allen's "Data Wire 4"
QUOTE
Data Wire Four v01.08.02
The Data-Wire Four is a Foxpro procedure designed to allow an application to verify databases quickly and easily.
In essence, the programmer executes DW4, generating a data dictionary program. When executed, this program verifies that all specified databases exist and have the correct field layouts. Structural indices are verified. Both Foxpro 2.6 and Visual Foxpro DBF formats are maintained. <ASP> approved.
Data Wire Four will now repair invalid/missing memo files. To repair a corrupted memo file, DW4 will first repair the memo file header. A new DBF file is then created and original data appended. While this process cannot guarantee full memo data recovery, at least the DBF file should be good.
END QUOTE
I found it, via a sugestion on this forum, at....
I have used DW4 and it does an amazing job.
Ken F
QUOTE
Data Wire Four v01.08.02
The Data-Wire Four is a Foxpro procedure designed to allow an application to verify databases quickly and easily.
In essence, the programmer executes DW4, generating a data dictionary program. When executed, this program verifies that all specified databases exist and have the correct field layouts. Structural indices are verified. Both Foxpro 2.6 and Visual Foxpro DBF formats are maintained. <ASP> approved.
Data Wire Four will now repair invalid/missing memo files. To repair a corrupted memo file, DW4 will first repair the memo file header. A new DBF file is then created and original data appended. While this process cannot guarantee full memo data recovery, at least the DBF file should be good.
END QUOTE
I found it, via a sugestion on this forum, at....
I have used DW4 and it does an amazing job.
Ken F
- Status
