distal-attribute
distal-attribute
distal-attribute
distal-attribute

Sticky Columns

User, date Message
Written by Frank Grimes
3 years ago
Category: Feature discussion
3 posts since Tue, 04 Oct 11
Is it possible to make a column always visible?

When I have a table with many columns I need to always scroll to the first column to see the ID of the row. Ok, I can hide some columns, but sometimes I need all columns to verify modifications made by my scripts.

For me it would suffice to have an option to make first Column sticky.

Many Thanks
Written by ansgar
3 years ago
5042 posts since Fri, 07 Apr 06
I had the same idea some time ago, and tried to make primary key columns sticky. There is support for such "stickyness" in VirtualTree, so I tested that, but got various access violations when I did so, don't ask me why. Probably I should try again with the latest sources.
Written by ansgar
3 years ago
5042 posts since Fri, 07 Apr 06
Ah, coFixed is the right option for this in VirtualTrees. I just tested that. If I set only 1 or 2 leftmost columns in that grid everything's fine. If a primary column is somewhere in the middle and I scroll to the right that column gets partly overlapped by its left neighbours - ugly. I'm sure someone will complain about that as soon as I commit that, although you might say this is a minor glitch, do you?
Written by Frank Grimes
3 years ago
3 posts since Tue, 04 Oct 11
1. Thanks a lot for testing it so fast :)

2. yes, this is only a minor glitch. A "nice to have". Normally I use SQLYog but it doesnt have it too. But you can make an option to make only the leftmost column sticky (In Data View, so I can turn it fast on and off). Mhhh, perhaps you will then get a feature request to make primary key sticky :)
Or can you reorder the columns? When somebody has his PK in the middle and make the column sticky then this column will move to the left border. In my opinion it make no sense to make a column in the middle sticky.
 

Please login to leave a reply, or register at first.