AnsweredAssumed Answered

Phantom records

Question asked by RickWhitelaw on Feb 4, 2016
Latest reply on Feb 4, 2016 by gdurniak

     Something interesting happened a couple of days ago. A printing script which was quite long and involved subscripts started printing forms (pay slips) with no values. Except for the first record in the found set. I tried many things and must have printed out 100 pages to no avail. Then I debugged the script going through all of the hundreds of steps and noticed that when one subscript went to the last record of the set it had no values except for a nonsense date. All other fields were blank. I copied the date, exited the script and performed a find on the date. No dice. Aha. Phantom records. i couldn't find them but I could see them if I was on a particular layout. So I painstakingly deleted the phantoms and for good measure saved a compacted copy any uploaded it to the server. I also checked it with recover. No issues. By the way the compacting process reduced a 14.5 mb file to 9.5mb. Is this unusual? Anyway, problem solved. The reason I'm posting this is that the idea of phantom records (almost certainly tied to a particular layout) is something to consider when all other explanations fail.