Jump to content

Field content disappears

This topic is 4325 days old. Please don't post here. Open a new topic instead.

Recommended Posts

We have a field in our fm6 (we're in the process of converting files at the moment) customer database at work which shows the salesperson for that customer. Recently this field started emptying itself...

This field is unmodifiable in all layouts except in a duped layout for finding and another where certain users can edit the value and are forced through a process where a script is triggered creating a record in a separate report file noting what changes were made, by who and when.

So all of a sudden this field keeps showing up with no data in it. But only for some records and not the same ones each time. My colleague and I searched every single script for any reference to this field on a number of occasions and we cannot for the life of us recreate the problem...

I know for a fact that in the past this file has been improperly closed and also recovered a number of times (before I worked here might I add!) so there is a possibility of corruption in the database. Is this behaviour something that could be caused by corruption or am I missing something? Any suggestions?!

Anyone else had this problem?

Help please!

Vicky x

Link to comment
Share on other sites

Have you tried turning off indexing for the field, exit the Manage >>Database and then going back in to Manage Database and turning on Indexing?

Thanks for your response Lee, I will try this tonight - as I'm sure you're well aware I cannot get into database definitions at all during 9-5:30 as I have to boot everyone out of the system. I will let you know if I have any luck...


Link to comment
Share on other sites

  • 3 weeks later...

Ok so messing around with indexing didn't work.... Any other suggestions aside from hurrying up with upgrading to fm11!?! x

You might try saving a copy as "Compressed Copy (smaller), but it sounds like you have corruption in this file. Although FileMaker 6 was probably the most stablest of the fp5 file structures, It would sometimes fail for no obvious reasons.

I just did a search in Google for filemaker corruption and got a ton of hits. I spotted a couple that sound like help for you.

Also, do an Advance search of FM Forums for Keywords +corruption +index and you will get 36 hits. Advance Search is the Gear Icon located at the top Right of the page.



Link to comment
Share on other sites

This topic is 4325 days old. Please don't post here. Open a new topic instead.

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

  • Create New...

Important Information

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