I’ve a pesky bug in one of my tab panels. Clicking on the column names has no action. I can switch the columns about, resize them, but cannot sort.
Several versions back sorting this tab panel works just fine. I’ve vigorously compared both versions. For the life of me I can’t see any differences in setup or structure. I’ve recreated this tab panel on a completely different form. Still doesn’t work.
On a long shot, perhaps someone else has experienced this difficulty and knows the probable cause.
kazar:
Morley, is that a table or portal on the tab panel? If it’s a portal, is the sortable property set in portal properties?
No, both are definitely tab panels. The form in both cases is set to Table View (locked).
I’ve compared screenshots of the various properties involved, both versions (the one that works, the one that doesn’t). Absolutely nothing is different, even sizes and location on screen – identical.
pbakker:
Columns based on a Calculation are not sortable. Never heve been, not in Tableviews and in Portals.
Is this maybe the reason?
This gets stranger and stranger.
One of the columns was indeed based on an indexed date calc. Changing it to a standard date field has no effect. The tab panel is based on a relationship is partly based on date calc. Changing the relationship to be based on a date field has no effect.
In the old version (fully functional) the column was based on a standard date field and the tab panel relationship includes the indexed date calc.
By the way, all the date calc does is return just the date portion, lopping off the time so it will match with the global date field which is also just date, no time. Identical relationship and date calc in both the current and old versions.
So, in this instance a calc isn’t a problem in the tab panel relationship, at least in the old version. And removing all calcs out of the situation has no effect on the new version. Reluctant conclusion: the problem is due to something other than calcs. Hmmm.
Solution found. The fields being sorted depended on a relationship. By creating a calculation that returns the same results and then indexing it and then placing the calc on the form instead of the relationship, sorting now functions.
Oddly enough, my earlier version which still works just fine has relationship fields. But the above methodology solves the problem at hand.