Sticky Columns

[expired user #5955]'s profile image [expired user #5955] posted 13 years ago in Feature discussion Permalink
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
ansgar's profile image ansgar posted 13 years ago Permalink
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.
ansgar's profile image ansgar posted 13 years ago Permalink
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?
[expired user #5955]'s profile image [expired user #5955] posted 13 years ago Permalink
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.