PDA

View Full Version : Page Down/Up Problem


ABC123

dparkins
02-01-2005, 06:02 AM
I have a form that will not allow the user to page up and when they hit the page down key, it advances two records and not one. This only happens when the user choose a certain index and it doesn't happen when the data is in record number order. the index is very simple and straight forward: Years=2005

Any advice is appreciated.
Thanks,
Dave

Al Buchholz
02-01-2005, 10:08 AM
Dave

Is the the index unique only and it's skipping to the next value?

Does rebuilding the indices or packing the table affect the behavior?

Can you take a screen shot of the index specs and post it?

dparkins
02-01-2005, 11:19 AM
Al,
The Alphaco and Firstboo indexes work fine and you can page up and down with them but not the Coid and Years2005 indexes. I can only page down with the Years2005 and go only page down and up once with the Coid indexes. I've never had this problem before. I've packed the entire database and even re-created and re-built the problem index.

Dave

dparkins
02-01-2005, 11:26 AM
The image isn't very good so I'll just spell them out for you.

Alphaco ALPHACO+INVERT(STR(YEARS,4,0)) Ascending All
Coid COID Ascending All
Firstboo FSTBOOTHNO YEARS=2005 Ascending All
Years2005 ALPHACO YEARS=2005 Ascending All

dparkins
02-02-2005, 07:23 AM
Al, I solved the problem I guess. I just renamed the indexes and the paging problem no longer exists. I would think if there was corruption with a name that it would have been resolved when I did a database compact but the problem is solved nonetheless. Thanks.

Dave

Al Buchholz
02-02-2005, 08:38 AM
Are the new index names 10 characters or less?

dparkins
02-02-2005, 08:43 AM
Yes, the old ones were as well.

Dave