Problem with list view - need help or info

[gfeier]

Please bear with me, this is tough to explain. I am using 6.0v3 on a Mac running 10.2.1. Everything was fine until I added the 8192nd record. With 8191 and a total line in list view, everything works fine. When I added five more records and sorted, the last four records and the total line disappeared, to be replaced by a copy of the first five records. They aren't really there, though. Selecting one of them and switching to form view shows the correct record, but I don't see it in list view. Table view works fine. It looks like there's a wraparound situation at 8192 records and I suspect it's a bug or program limitation since 8192 is 2 to the 13th power. Bad luck, I guess. Anybody have any info or ideas?

[CyberSport]

Hm. I just tried this by making a simple DB and adding 8191, 8192, and 8193 records, only fields defined being a autogenerated unique number and a total, did a simple sort and looked in all 3 views. Didn't find the bug. Any more description of the problem? Total file size?

Bevin

[gfeier]

The file size is only 2.1MB. There are only 8 fields. Are you running on a Mac or PC, CyberSport?

[CyberSport]

mac, but 10.1.5

still am pouting about paying for upgrade until i am so jealous of all my friends who have moved to jaguar that i can't resist any longer.

[gfeier]

Oh, go ahead. I coughed up the bucks and I'm not sorry. I emailed someone else a copy of the file and he couldn't replicate the problem. I have a couple of ideas on how to proceed if it's not a normal occurrence with the program, but it'll be at least a week before I can try them. Guess I'll use up my one free support call tomorrow.

[gfeier]

You're gonna love this, CyberSport! I called FileMaker today and the tech had me create a new layout while on the phone. It worked perfectly, of course, so I ended the call and spent some time matching the layout exactly to the problem layout. After I was done - the problem was back! I checked it out step by step and here's what I came up with:

Everything works until I move the lines between layout parts closer together. More precisely, when I move the trailing grand summary up closer to the body, the problem appears and when I move it back, the problem goes away. My original layout had the lines very close together so the problem came up as soon as I hit the right number of records. When I created a new layout, there was no trouble until I moved that line up in layout mode. I went back to my problem layout, lowered the line about a pixel and voila! Problem solved. I moved the line back and forth a couple of times to confirm the results and it happened every time. That was a fun one. Let's not do it again soon!

[CyberSport]

wow. that's quite amusing (well, unless i had been YOU!)--some of the quirks of this system are enough to make me pull out my hair. did you have any data IN the trailing grand summary? shaking head...

[gfeier]

Nope. Just two simple field totals. On another topic, can you recommend any good FM Pro 6 books?