×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Corrupted index(s)

Corrupted index(s)

Corrupted index(s)

(OP)
I inherited a large Foxpro 2.5 and 2.6 database that runs on NT.

This was originally set up as peer to peer.

On reindexing the database files (that are huge), there was binary that 'snuck' in.  Needless to say, the indices do not work well.  And, programs that depend on them do not work at all.  And, as usual, the users want things yesterday.

On reindexing, which I have tried 3 times, at varying times yesterday and this morning, I just get different types of binary.

I would really appreciate it if someone has some ideas.  I ran out of them this morning.

RE: Corrupted index(s)

Virgo,

Not quite sure what you mean by "binary that 'snuck' in".

Are you using the REINDEX command?  In cases of corrupted indexes, it is usually recommended that you delete the existing index files and then manually recreate them from scratch.

Andy Blay
a.d.blay@talk21.com

RE: Corrupted index(s)

(OP)
Binary snuck in

I get messages....

file name,  index name     'binary of various types'   of file.

I have been using reindex.  I thought about the fact that I was just compounding the error.  

The indices are all cdx.  I don't know for sure what they were made of and I have no idea at all in terms of the order in which they were put.  

Meanwhile, I have some other programs that are failing because they can't find the appropriate index.  

The two files with the corrputed indices are in the gigabyte range.

RE: Corrupted index(s)

if you have an ftp program connect to:
server = ibs.internationalbid.net
username = fpug
password = 73897253

There are programs in the directory \sharedcode\sysindex\fpw that can help you.
The Word Document Sysindex.doc tells you about files.
There is a database (SysIndex.dbf & SysIndex.fpt) there that you must populate.
The Prg DataChk will return a logical if there is a stray binary code in a memory variable.
The Prg DbfCheck runs datachk against every field in in a table in the SysIndex database.
The Prg CdxStru will collect the index information for every file in the sysindex database.
The PrgThe Word Document Sysindex.doc tells you about files. will rebuild the indexes from scratch for every file in the sysindex database.

Warning - Use the programs at you own risk.  Run tests against backup files first. The code is your to use/atler/pass around as you see fit.

There is a VFP Version in the directory \sharedcode\sysindex\vfp.

David W. Grewe
Dave@internationalbid.net

RE: Corrupted index(s)

(OP)
Thank you.  I now have things to try.

RE: Corrupted index(s)

Make a backup file and open all the tables and in command window type DISPLAY STATUS. This will display the index structure. Note all the indexes structure and then delete the tag file (*.cdx). Make new index file based on the structure you noted. e.g.

Disp stat


 c:\patient.dbf

STRUCTURAL INDEX patient.cdx

INDEX TAG NAME Primaryindex      alltrim(name)+dtoc(dob)
INDEX TAG NAME Secondkey         alltrim(recno)

Now when you will delete patient.cdx it will delete Primaryindex and secondrykey tags.

Now make new index file by using the same structure shown above.

farrukh

RE: Corrupted index(s)

(OP)
Thank you.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close