VickyNesbitt Posted March 16, 2011 Share Posted March 16, 2011 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 More sharing options...
Lee Smith Posted March 16, 2011 Share Posted March 16, 2011 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? Link to comment Share on other sites More sharing options...
VickyNesbitt Posted March 17, 2011 Author Share Posted March 17, 2011 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... x Link to comment Share on other sites More sharing options...
VickyNesbitt Posted April 5, 2011 Author Share Posted April 5, 2011 Ok so messing around with indexing didn't work.... Any other suggestions aside from hurrying up with upgrading to fm11!?! x Link to comment Share on other sites More sharing options...
Lee Smith Posted April 5, 2011 Share Posted April 5, 2011 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. HTH Lee Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4784 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 accountSign in
Already have an account? Sign in here.
Sign In Now