Jump to content
Sign in to follow this  
El_Pablo

Getting nervous on strange searching problem

Recommended Posts

Hi,

I'm having a big problem... I transfered records from a corrupted DB on a clone, but all the indexes in the new db don't seem to work. When I'm doing a search on the primary key, it never finds the record. I tried with an existing record...

Does anyone had this problem before?

Share this post


Link to post
Share on other sites

Try turning off indexing for each key field. Because they're in relationships, fm will rebuild the indices.

Share this post


Link to post
Share on other sites

Out of curiosity, what version of FM 8 are you running?

Share this post


Link to post
Share on other sites

The files have been developped in many versions.. 8v1, 8v2, 8v3, 8.5v1 and 8.5v2.

So the first solution, would be to remove all the indexes... D'OH!

I'll try this.

Thank you

Share this post


Link to post
Share on other sites

Also, make sure, if this is served, that you're running the latest version of server. I believe there was a know issue with indices.

Share this post


Link to post
Share on other sites

I do not see an update for version 8.5.v2

Lee

Share this post


Link to post
Share on other sites

Hi Lee,

8.5v2 is Windows Specific update for those using Vista.

http://www.fmforums.com/forum/showtopic.php?tid/185609

Share this post


Link to post
Share on other sites

I will remove all the indexes live today. Hoping that doing this would not crash the DB!

Share this post


Link to post
Share on other sites

Before you do that it is important that you upgrade all the 8.0v1 and 8.0v2 clients to 8.0v3.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.